Forum Discussion

mogugu_84's avatar
mogugu_84
Icon for Helper I rankHelper I
1 year ago
Solved

Switch measure using parameter in SUM formulas

Hi    i have a created a parameter (called "choose measure" to switch between unit and cash) and it works for simple charts with no calculated field   the parameter looks like this:   Choose ...
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi mogugu_84 ,

     

    As far as I know, if you want to use Field parameter function, you need to add all measures you need in it instead of only add the column.

    For example, you need create two measures [LYTD Retail Cash] and [LYTD Retail Units] for LYTD Retails, and the same for others like YTD Retail and FYTD Growth Retail.

    I suggest you to add a calculated column in this parameter table.

    Choose measure = IF(CONTAINSSTRING(Parameter[Parameter],"Cash"),"Retail Cash","Retail Units")

    Then use this column to create a slicer. Result is as below.

     

     

    Best Regards,
    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

     

     

Kedar_Pande's avatar
Kedar_Pande
Icon for Super User rankSuper User
1 year ago

mogugu_84 

In the DAX use the paramenter insted of the direct column.

ex

LYTD Retail =
CALCULATE(SUM('ParameterSwitch'[Parameter]),DATESYTD(dateadd('Calendar'[Date],-1,Year),"3/31"))


💌 If this helped, a Kudos 👍 or Solution mark would be great! 🎉
Cheers,
Kedar
Connect on LinkedIn

mogugu_84's avatar
mogugu_84
Icon for Helper I rankHelper I
1 year ago

Hi Kedar, sorry, not sure i got this right, i tried copy your formula directly, it doesn't work

Also tried to replace it with my parameter name "choose measure", also doesn't calculate....