Forum Discussion
Anonymous
7 years agoNot applicable
Calculate with DISTINTCOUNT doesn't return expected value to calculate Backorders
Hello everybody, I'm just getting started in Power BI and I can't find the way to get an expected result. Hope you can help me.
Let explain the idea, I need to count each time an Extra INVOICE is executed by order. For example in order 1, count 1 backorder. I would like to get the total Grouped By CUSTOMER as shown in the right image. I know the COUNT in BACKORDER match with values, but is not counting that I really need.
The matrix should show 4 where indicated.
I would really appreciate any help, have a nice day.
Anonymous ,
You may refer to the measure below.
Measure = SUMX ( VALUES ( Table1[ORDER] ), CALCULATE ( DISTINCTCOUNT ( Table1[INVOICE] ) - 1 ) )
2 Replies
- v-chuncz-msft
Community Support
Anonymous ,
You may refer to the measure below.
Measure = SUMX ( VALUES ( Table1[ORDER] ), CALCULATE ( DISTINCTCOUNT ( Table1[INVOICE] ) - 1 ) )- AnonymousNot applicable
Thank you for the timely answer, hope it can help others in the future.