Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi Guys.
Trying to get the total count of a measure. I have a measure that calculates the count of equipments if the acheived is higher than target. In the example below, for Dozers should be 4 instead of 5. Similiarly Truck should be 9 instead of 12. And Excavator total should be 1 instead of blank. Can I please ask for some help on this.
Solved! Go to Solution.
@azakir , You need to have measure like
Countrows(filter(Summarize(Table, Table[Equipmement Class],Table[Equipmement Code], "_1", if([M1] > [M2]+0 ,1, 0) ), [_1] >0 ) )
@azakir , You need to have measure like
Countrows(filter(Summarize(Table, Table[Equipmement Class],Table[Equipmement Code], "_1", if([M1] > [M2]+0 ,1, 0) ), [_1] >0 ) )
Thanks @amitchandak . Had to redo the measure with some modifications, but it worked:
User | Count |
---|---|
80 | |
74 | |
62 | |
61 | |
46 |
User | Count |
---|---|
108 | |
97 | |
88 | |
81 | |
61 |