Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Having an issue with aggr measure when the dimension is present as a filter as well as in table.
It's showing two figures when filter is selected and when it is not. I need same out put at a contract level.
Exp: Count(distinct {<[Cust_id]={"=Sum(Sales)>0"}>}Total <Contract_id>[Cust_id]
Here Cust_id and Contract_id both are present in table dimension. Please guide. Ty
@JasonB1996 Correct me if I am wrong, as per my understanding you are trying to find the count of Customers whose Sum(Sales) >0
Aggr(Count(distinct {<[Cust_id]={"=Sum(Sales)>0"}>}[Cust_id]), [Contract_id],[Cust_id]))
Correct.