Forum Discussion

BI-Bola's avatar
BI-Bola
Frequent Visitor
6 years ago
Solved

Count Distinct where sum is

I am trying to get a distinct count of values where the sum of values is not zero   Below I have a basic distinct count:    Distinct Count = CALCULATE(DISTINCTCOUNT(AccountTransactions[Segment])...
Need Help
  • BI-Bola's avatar
    BI-Bola
    6 years ago

    Thanks for your suggestions all but strangely none worked with my dataset. I'm not sure if it's the size of the dataset or the fact that it is running through a direct query causing the issue.

     

    To get around it I created an additional table from the main query using a combination of the CALCULATETABLE, SUMMARIZE and FILTER functions and put a count card visual pulling data from new table.

BI-Bola's avatar
BI-Bola
Frequent Visitor
6 years ago

Thanks for your suggestions all but strangely none worked with my dataset. I'm not sure if it's the size of the dataset or the fact that it is running through a direct query causing the issue.

 

To get around it I created an additional table from the main query using a combination of the CALCULATETABLE, SUMMARIZE and FILTER functions and put a count card visual pulling data from new table.