Forum Discussion

ksan048's avatar
ksan048
Frequent Visitor
8 years ago

Measure as Page Level Filter

Hi all,   I have  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.   First measure :  Calculates the LOS...
Need Help
v-yuta-msft's avatar
v-yuta-msft
Community Support
8 years ago

Hi ksan048,

 

To achieve your requirement, please use dax formula below:

LOS Worse than Last Month =
VAR LOS_Last_Month_Score =
    CALCULATE ( AVERAGE ( Sheet1[LOS Score] ), DATEADD ( Sheet1[Date], -1, MONTH ) )
VAR LOS_Month_Score =
    CALCULATE (
        AVERAGE ( Sheet1[LOS Score] ),
        DATEADD ( Sheet1[Date].[date], 1, MONTH )
    )
RETURN
    IF ( LOS_Last_Month_Score < LOS_Month_Score, "Y", "N" )

 

Regards,

Jimmy Tao

ksan048's avatar
ksan048
Frequent Visitor
8 years ago

 

v-yuta-msft

 

Thanks for replying. I gave it a go and it seemed to only return me 'N'.

 

I stuck all the measures in a table including the solution you  provided which I have named the column as 'LOS worse' as shown below. (I have omitted the first column of IDs from the image).

 

I'm new to Power BI and need a bit of guidance! 

 

Thanks a lot!

  • wildmight2017's avatar
    wildmight2017
    Advocate II
    8 years ago

    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. 

    • ksan048's avatar
      ksan048
      Frequent Visitor
      8 years ago

      wildmight2017 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.......