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]),Metric...
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
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...