Forum Discussion

azakir's avatar
azakir
Resolver I
3 years ago
Solved

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 ins...
Need Help
Show and Tell
  • amitchandak's avatar
    amitchandak
    3 years ago

    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 ) )

amitchandak's avatar
amitchandak
Super User
3 years ago

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's avatar
    azakir
    Resolver I
    3 years ago

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

  • azakir's avatar
    azakir
    Resolver I
    3 years ago

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