Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Create a constant value using DAX that wont be affected by filters

Hello all,

 

I am trying to create a measure that will be a constant value that wont be affected by slicing. 

 

the measure currently is 

 

SalesIsLatest = CALCULATE(SUM(Metrics[Sales]),Metrics[islatest] =1)
 
I need this value to remain static so I can create a tooltip calculation 
 
is this possible? 
 
thank you!

 

 

 

Need Help
Tips and Tricks
  • az38's avatar
    az38
    6 years ago

    hi Anonymous 

    not clearly understand but you can use 

    SalesIsLatest = CALCULATE(SUM(Metrics[Sales]),Metrics[islatest] =1, ALL(Metrics))

    there will be SUM() by whole amount of data and it will the same in any case

     

    also you can use the simple

    SalesIsLatest = 20

3 Replies

  • az38's avatar
    az38
    Icon for Community Champion rankCommunity Champion
    6 years ago

    hi Anonymous 

    not clearly understand but you can use 

    SalesIsLatest = CALCULATE(SUM(Metrics[Sales]),Metrics[islatest] =1, ALL(Metrics))

    there will be SUM() by whole amount of data and it will the same in any case

     

    also you can use the simple

    SalesIsLatest = 20
    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      thank you az38 I tried using ALL but i was doing it slightly incorrect 

       

      thank you for the help

    • Data4Me's avatar
      Data4Me
      Frequent Visitor
      2 years ago

      Briiliant this resolved the issue I had, as I calculated a total percentage, but when clicking on a filter it kept staying as 100% until I used the all function.

      So I now get a total for 100% and percetanges when a filter is clicked on.

      Thanks you so much for your help - as even Chat GBT did not bring this answer...