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
Ashish_Mathur's avatar
Ashish_Mathur
Super User
2 years ago

Hi,

Share the download link of the PBI file.

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:

  • lbendlin's avatar
    lbendlin
    Super User
    2 years ago

    I cannot assist you if you are unable to provide sample data. I hope someone else can help you further.

    • 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

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