Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
Solved! Go to Solution.
@Anonymous ,
You may refer to the measure below.
Measure = SUMX ( VALUES ( Table1[ORDER] ), CALCULATE ( DISTINCTCOUNT ( Table1[INVOICE] ) - 1 ) )
@Anonymous ,
You may refer to the measure below.
Measure = SUMX ( VALUES ( Table1[ORDER] ), CALCULATE ( DISTINCTCOUNT ( Table1[INVOICE] ) - 1 ) )
Thank you for the timely answer, hope it can help others in the future.
User | Count |
---|---|
124 | |
108 | |
99 | |
62 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |