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
vNum / vDen
But When user selects the value in Solicer Denominator also changes, I want Denominator to stay constant.
Go to Solution.
I belive what @natelpeterson 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 @natelpeterson post.
@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,
@natelpeterson Sorry, I'm new to DAX. COuld you please furher elobrate or give me the syntax?
@Jorgast - Yes, that's what I meant - thanks.
Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.
We spoke with Power BI Super User, Greg Deckler, about his charity work
Continue your learning in our online communities.