Create a DAX measure that ignores all filters

[Anonymous]

Hi there,

Not sure my dream is possible and i've been fiddling with 'ALL' to no avail. 

I have a measure which is =SUM('Table'[Invoice Count])

And I want a second measure, exactly the same function, but that will ignore any filter applied within my report. I know I can edit interactions to achieve this, but the reason I want the unchangeable measure is because I want the changeable measure to change colour based on whether it is higher, lower or the same as the unchangeable measure. For this, I need a static measure.

This way, when people apply filters to the data, they can see the original unfiltered number next to the filtered number, which will tell them whether the filter has increased or decreased the value, and be a nice pretty colour. 

Thanks in advance for any suggestions 🙂

[amitchandak]

@Anonymous , I think you already have a solution 🙂 . Also, explore - ALLCROSSFILTERED

calculate(SUM('Table'[Invoice Count]),ALLCROSSFILTERED('Table'))

https://www.linkedin.com/pulse/five-recent-power-bi-functions-you-should-use-more-often-amit-chandak/

[PaulDBrown]

@Anonymous 

How about:

ALL measure = CALCULATE( [your measure], ALL( Table))

Edit: looks like @Greg_Deckler  "beat" me by 23 seconds and actual options!

[Greg_Deckler]

@PaulDBrown - That's a riot! 🙂

[amitchandak]

@PaulDBrown , I think, It is really difficult to be faster than @Greg_Deckler for me, atleast. I think the only way I can be faster than him, that he sees a problem a couple of mins after I do.  😀

[Greg_Deckler · Accepted solution]

@Anonymous 2 ways:

CALCULATE(SUM('Table'[Invoice Count]),ALL('Table'))

SUMX(ALL('Table'),[Invoice Count]))

[Anonymous]

Thanks @Greg_Deckler this worked for me!