Count Measure

[azakir]

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.

[amitchandak · Accepted 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]

Thanks @amitchandak . Had to redo the measure with some modifications, but it worked: 

[azakir]

Thanks @amitchandak but that didn't work. Is the measure correct ?