Forum Discussion

ligalbert's avatar
ligalbert
Icon for Helper I rankHelper I
4 years ago
Solved

How can I count based on the table I created using measures

I want to count the values of 06--30. I created 06--30 as a measure and I'm not sure how to count the values of a measure 

Is there a way I can count the values of the measure I created 

 

Need Help
Show and Tell
  • ryan_mayu's avatar
    ryan_mayu
    4 years ago

    ligalbert 

    maybe you can try this

    Measure = if(NOT(ISBLANK('Table'[06-30])),1,0)
measure2 = sumx(VALUES('Table'[ID]),'Table'[Measure])

1 Reply

  • ryan_mayu's avatar
    ryan_mayu
    Icon for Super User rankSuper User
    4 years ago

    ligalbert 

    maybe you can try this

    Measure = if(NOT(ISBLANK('Table'[06-30])),1,0)
measure2 = sumx(VALUES('Table'[ID]),'Table'[Measure])