Forum Discussion

th340385's avatar
th340385
Icon for Helper I rankHelper I
2 years ago
Solved

Dax Measure Help

Hello,    I have a dataset that I am trying to calculate the total number of rows >= a specific stage number.    My current measure is:  Count by Stage = CALCULATE([Count All Rows], FILTER(ALLSE...
Need Help
Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
2 years ago

Hi,

This works for me

C = COUNTA(Data[Stage])
Measure = CALCULATE([C],FILTER(ALL(Data[Stage]),Data[Stage]>=MIN(Data[Stage])))

 

th340385's avatar
th340385
Icon for Helper I rankHelper I
2 years ago

Thank you, but I am able to get that measure to work. I am trying to get step two (see below). I would like to see the cummulative count at each stage. 

 

Stage #123
Cummulative #1772
    • th340385's avatar
      th340385
      Icon for Helper I rankHelper I
      2 years ago

      This was perfect! Thank you!

      • Ashish_Mathur's avatar
        Ashish_Mathur
        Icon for Super User rankSuper User
        2 years ago

        You are welcome.