topic Re: Aggr sum distinct issue in App Development

Aggr sum distinct issue

Mayur_Bisht — Thu, 07 Jul 2022 12:07:47 GMT

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 — Fri, 08 Jul 2022 02:32:12 GMT

@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 — Fri, 08 Jul 2022 06:00:44 GMT

Correct.