Forum Discussion
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])...
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.
Anonymous
Original post updated
I am after a distinct count of the segment column values where the sum of "Amount" is not equal to zero