Forum Discussion

Oggie's avatar
Oggie
Frequent Visitor
2 years ago
Solved

Filter a Measure with a parameter

Hi,   I am trying to write a measure that allows me to switch between different measures, where "KPI Net Revenue Act MTD" and "KPI Net Revenue Act YTD" are the "base measures" that should be shown ...
Need Help
  • rajendraongole1's avatar
    rajendraongole1
    2 years ago

    Hi Oggie  - Ensure that you have a base measure has been created,

    create one more new measure as follows with selectedvalue func and add it to your card visual.

    KPI Net Revenue Act =
    VAR SelectedKPI = SELECTEDVALUE('KPI Comparison Net Rev'[KPI Comparison Net Rev])
    RETURN
    IF(
    SelectedKPI = "MTD vs Budget",
    FORMAT([Net Revenue Act MTD] / 1000, "# ###"),
    FORMAT([Net Revenue Act YTD] / 1000, "# ###")
    )

     try above and let know

     

    Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!

  • Oggie's avatar
    Oggie
    2 years ago

    I managed to solve it with your help, but I had to change the Selected value from "the composite key" to the actual field key, ie the code ended up like the following:

    KPI Net Revenue Act =
    VAR SelectedKPI = SELECTEDVALUE('KPI Comparison Net Rev'[KPI Comparison Net Rev Fields])
    RETURN
    IF(
    SelectedKPI = "
    'Measure groups'[KPI Net Revenue Act MTD vs Budget]
    ",
    FORMAT([Net Revenue Act MTD] / 1000, "# ###"),
    FORMAT([Net Revenue Act YTD] / 1000, "# ###")
    )
     
    Thanks for your help!
rajendraongole1's avatar
rajendraongole1
Super User
2 years ago

Hi Oggie  - Ensure that you have a base measure has been created,

create one more new measure as follows with selectedvalue func and add it to your card visual.

KPI Net Revenue Act =
VAR SelectedKPI = SELECTEDVALUE('KPI Comparison Net Rev'[KPI Comparison Net Rev])
RETURN
IF(
SelectedKPI = "MTD vs Budget",
FORMAT([Net Revenue Act MTD] / 1000, "# ###"),
FORMAT([Net Revenue Act YTD] / 1000, "# ###")
)

 try above and let know

 

Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!

Oggie's avatar
Oggie
Frequent Visitor
2 years ago

I managed to solve it with your help, but I had to change the Selected value from "the composite key" to the actual field key, ie the code ended up like the following:

KPI Net Revenue Act =
VAR SelectedKPI = SELECTEDVALUE('KPI Comparison Net Rev'[KPI Comparison Net Rev Fields])
RETURN
IF(
SelectedKPI = "
'Measure groups'[KPI Net Revenue Act MTD vs Budget]
",
FORMAT([Net Revenue Act MTD] / 1000, "# ###"),
FORMAT([Net Revenue Act YTD] / 1000, "# ###")
)
 
Thanks for your help!