Aggr sum distinct issue

[Mayur_Bisht]

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

[sidhiq91]

@Mayur_Bisht 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]))

[Mayur_Bisht]

Correct.