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
     
selimovd's avatar
selimovd
Most Valuable Professional
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
 
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Just wanted to thank you for this, I was having the same exact issue and this solved it perfectly!! Now I know I have to remove a sort by feature on a column as well