Forum Discussion
Count Measure
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.
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 ) )
3 Replies
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 but that didn't work. Is the measure correct ?
Thanks amitchandak . Had to redo the measure with some modifications, but it worked:
