Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

ALL function not working as expected

Hi all,   I am trying to get the grand total (1382889.95) showing for each row in "Measure" by using ALL function, but it doesn't seem like it's working. Anyone know what's wrong with my dax?   B...
Need Help
Show and Tell
  • selimovd's avatar
    selimovd
    5 years ago

    Hey Anonymous ,

     

    can you check if the column Fact_Sales[Type] has a sort by column?

    If yes, then you also have to remove that filter:

    MyMeasure =
CALCULATE(
    SUM( Fact_Actual[Revenue] ),
    ALL( Fact_Sales[Type] ),
    ALL( Fact_Sales[SortByColumn] )
)

     

    If you need any help please let me know.
    If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
     
    Best regards
    Denis
     
Jihwan_Kim's avatar
Jihwan_Kim
Super User
5 years ago

Hi, Anonymous 

Please try the below.

 

Measure = CALCULATE(SUM(Fact_Actual[Revenue]), ALL(Fact_Actual))

 

Hi, My name is Jihwan Kim.

 

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

 

Linkedin: linkedin.com/in/jihwankim1975/

Twitter: twitter.com/Jihwan_JHKIM