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?

 

Both columns are from the same Fact table

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

 

 

Regards,

BK

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
     

4 Replies

  • 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

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

  • 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