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 in this card below as the large number (using the Subtitle field). I have managed to get one measure there but want to switch it using a filter.
 
I have set up the following measures. 
 

 The measures are then grouped together using the Field Parameter function giving me a filter like the one below:

 

 

Now I am trying to write a new measure that allows me to switch based on the selected value in the filter.  Is it possible to write something like this?

----
KPI Net Revenue Act = IF(SELECTEDVALUE('KPI Comparison Net Rev'[KPI Comparison Net Rev])="MTD vs Budget",FORMAT([Net Revenue Act MTD]/1000, "# ###"),FORMAT([Net Revenue Act YTD]/1000, "# ###"))
----
The current code gives me the following error:

 

Kind of new to Power Bi and DAX... so could be easy... 🙂 Please help!

 

Best regards

Stefan

 
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!

2 Replies

  • 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!