Forum Discussion
Distinct Transaction Count with Same or Different Person
The goal is to be able to count the number of transactions made by a manager regardless the number of assistants. Below is sample data which along with expected (correct) output + current (incorrect)...
Hi Anonymous ,
I made simple samples and you can check the results below:
Measure = CALCULATE(DISTINCTCOUNT('Table'[Case_ID]),ALLEXCEPT('Table','Table'[Manager]))An attachment for your reference. Hope it helps!
Best regards,
Community Support Team_ Scott ChangIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous ,
I made simple samples and you can check the results below:
Measure = CALCULATE(DISTINCTCOUNT('Table'[Case_ID]),ALLEXCEPT('Table','Table'[Manager]))
An attachment for your reference. Hope it helps!
Best regards,
Community Support Team_ Scott Chang
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.