Forum Discussion

bogomda's avatar
bogomda
Resolver I
7 years ago
Solved

measure calculation - very odd problem

i wrote a simple measure

Managed Services =
CALCULATE(
     SUM(Budget[Amount], 
     Budget[Account Group] = "Managed Services")

which internally should translate into:

 

 CALCULATE(
         SUM(Budget[Amount]),
         FILTER(
              ALL(Budget[Account Group]),
              Budget[Account Group] = "Managed Services"
  )

Measure returns incorrect result when i put Budget[Account Group] field as a row filter on the visual. i don't have any other filters on the report. What could be a problem?

 

Need Help
  • Baskar's avatar
    Baskar
    7 years ago

    bogomda 

     

    Got it the issue, You are 100 % correct it is becasue of the sorting order. 

    Try this, It will help you. 

     

    Managed Services Budget ALL =
    CALCULATE([Total Budget],FILTER(ALL(Budget[Account Group],Budget[Account Group Sort Order]),
    Budget[Account Group]="Managed Services"))
     

7 Replies

  • Baskar's avatar
    Baskar
    Resident Rockstar
    7 years ago

    bogomda 

    As per your dax code it is expected result. 

     

    Let me know what is your expected output here ?

     

    Do you want the same value in all blank cells ?

     

    Try this 

     

    Managed Services = CALCULATE(SUM(Budget[Amount]),
    FILTER(ALL(Budget[Account Group]),Budget[Account Group]="Managed Services"))

    • bogomda's avatar
      bogomda
      Resolver I
      7 years ago

      Baskar, yes i need same value in all blank cells.

      Measure below returns same result as the original measure. My understanding that internally they are identical anyway.

       

      CALCULATE(

            SUM(Budget[Amount]),

            FILTER(

                 ALL(Budget[Account Group]),

                 Budget[Account Group]="Managed Services"

            )

      )

       

      i never seen such a problem before.