Forum Discussion

th340385's avatar
th340385
Helper 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
th340385's avatar
th340385
Helper I
2 years ago

Unfortunately I am not able to provide same data. However, it is a very simple table with only two fields.  I think the first part of my measure is working correctly, but I want to aggregate the result even further as shown below:

Ashish_Mathur's avatar
Ashish_Mathur
Super User
2 years ago

I will need some file to work with.

  • th340385's avatar
    th340385
    Helper I
    2 years ago
    Stage
    1
    1
    1
    1
    1
    2
    2
    2
    3
    3

    The table above is very simple sample data that can be used in a pbix file. See below for updated screenshot of current measure and desired result using the sample data: 

     

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Super 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
        Helper 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