Constant Calculated measure value with slicer interaction

[sabeensp]

Hello,

I have a report with bunch of slicers, however all teh slicers value are pinned to same table "Model". I have craeted a Measure as below:

MeasureName = 
var vNum = CALCULATE (COUNT(TABLE1[COST] , Filter (Table1, Table1[Color] = "Blue") // This is Numerator

var vDen = CALCULATE (SUM(TABLE1[REVENUE] , Filter (Table1, Table1[Year] = 2019) , ALL (TABLE1)
// This is Denominator

RETURN

vNum / vDen

But When user selects the value in Solicer Denominator also changes, I want Denominator to stay constant.

Please help.

[Anonymous]

@sabeensp - You want to ignore the filter on a certain column. In other words, modify the natural filter context. To do this, you add an ALL('Table'[Column]) as a new parameter in your CALCULATE.

Hope this helps,

Nathan

[sabeensp]

@Anonymous  Sorry, I'm new to DAX. COuld you please furher elobrate or give me the syntax?

[Jorgast · Accepted solution]

@sabeensp 

I belive what @Anonymous is referring to is this code:

var vDen = CALCULATE (SUM(TABLE1[REVENUE] , Filter (Table1, Table1[Year] = 2019) , ALL('Table'[Column])

If this works for you, please accept @Anonymous  post.

[Anonymous]

@Jorgast - Yes, that's what I meant - thanks.