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

[Anonymous]

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!

[az38 · Accepted solution]

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

[Data4Me]

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...

[Anonymous]

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

thank you for the help