Forum Discussion

ngiam's avatar
ngiam
Icon for Helper I rankHelper I
5 years ago
Solved

How to perform COUNTIF on Measurement?

Hi,   How do I perform a countif using measurement?   I have a measurement created to categorize Strength, Weakness, Average.   Strength = SWITCH( TRUE, (((Sheet[Superior Score]+Sheet[Tea...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    ngiam , sorry my mistake

    Strength =

    countrows(filter(Sheet,Sheet[Strength] = "Strength"))

     

    Weakness=

    countrows(filter(Sheet,Sheet[Strength] = "Weakness"))

     

    Average=

    countrows(filter(Sheet,Sheet[Strength] = "Average"))

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

ngiam , if above is a calculated column, then you can create measure like

Strength =

countrows(filter(Sheet[Strength] = "Strength"))

 

Weakness=

countrows(filter(Sheet[Strength] = "Weakness"))

 

Average=

countrows(filter(Sheet[Strength] = "Average"))