Measure as Page Level Filter

Question

Hi all,&nbsp;I have&nbsp; a number of measures that I have created which are dependent on each other and I would like the last one to be sued as a page level filter.&nbsp;First measure :&nbsp; Calculates the LOS score for the last month&nbsp;&nbsp;LOS Last Month Score = CALCULATE(AVERAGE(Sheet1[LOS Score]),dateadd(Sheet1[Date],-1,month))&nbsp;Second measure:&nbsp; Calculates the LOS score for the&nbsp; month&nbsp;LOS Month Score = CALCULATE(AVERAGE(Sheet1[LOS Score]),dateadd(Sheet1[Date].[date],1,month))&nbsp;Third measure: Compares the 2 scoresLOS Worse than Last Month = if([LOS Last Month Score]&lt;[LOS Month Score],"Y","N")&nbsp;I then want to filter based on the last measure.&nbsp;How can this be done?&nbsp;Thanks&nbsp;&nbsp;

ksan048 · Answer

wildmight2017&nbsp;I hadn't manage to figure it out and ended up using Tableau instead as it accepted shape files that are of linestring types. I didn't need a workaround at all.......&nbsp;

v-yuta-msft · Answer

Hi ksan048,&nbsp;To achieve your requirement, please use dax formula below:LOS Worse than Last Month =VAR LOS_Last_Month_Score =&nbsp;&nbsp;&nbsp;&nbsp;CALCULATE ( AVERAGE ( Sheet1[LOS Score] ), DATEADD ( Sheet1[Date], -1, MONTH ) )VAR LOS_Month_Score =&nbsp;&nbsp;&nbsp;&nbsp;CALCULATE (&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;AVERAGE ( Sheet1[LOS Score] ),&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;DATEADD ( Sheet1[Date].[date], 1, MONTH )&nbsp;&nbsp;&nbsp;&nbsp;)RETURN&nbsp;&nbsp;&nbsp;&nbsp;IF ( LOS_Last_Month_Score &lt; LOS_Month_Score, "Y", "N" )&nbsp;Regards,Jimmy Tao

ksan048 · Answer

&nbsp;v-yuta-msft&nbsp;Thanks for replying. I gave it a go and it seemed to only return me 'N'.&nbsp;I stuck all the measures in a table including the solution you&nbsp; provided which I have named the column as 'LOS worse' as shown below. (I have omitted the first column of IDs from the image).&nbsp;I'm new to Power BI and need a bit of guidance!&nbsp;&nbsp;Thanks a lot!

wildmight2017 · Answer

Were you able to figure out a solution? I'm trying to achieve something similar - and getting the same issue of repeating value. My suspicion is that you need to apply certain ALL() statements for it to work properly given granularity.&nbsp;

Forum Discussion

Measure as Page Level Filter

4 Replies

Related content

Page Level filter for different groups

Dynamic measure filtering

Filter by Rank measure

Ignore page level filter in Measure

Ignore visual level filter from a measure