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
     
vanessafvg's avatar
vanessafvg
Community Champion
5 years ago

maybe do the all on the table instead of the column?

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