Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
81 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |