Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Parameters in Measures with Multiple Conditions

I need to create a measure that would allow a user to select multiple parameters to move the needle on a visual.

I need them to select:
Report Period
Amount to be removed by a Category  (Foundational, Growth or Unplanned)
Amount to be added by a Category 

 

Is this possible?


Here is my current visual and the measure that drives it

100% Stacked Investment Mix $ = 
VAR allmix = CALCULATE( [Labor Cost], ALL(CEProject[LE Investment Mix]))
RETURN
[Labor Cost]/allmix

Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    I actually ended up created a couple additional measures with calculations pulling from selected parameters that allowed me to do something a little differently but still gets the results.   

     

    Again everyone thanks for the ideas!

8 Replies

  • MFelix's avatar
    MFelix
    Icon for Super User rankSuper User
    6 years ago
    Hi Anonymous,

    This is possible you need to setup some slicers with the variable that you want to select and then using SELECTEDVALUE for each variable you can pick up the values from the slicers then just filter the calculation based on the variables.

    Can you share a sample of the data and expected results when the slicers are selected?
    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      This is kind of hard to put into a slicer because they want to be able to remove an amount of Labor Cost and then add a new labor cost based on several different scenarios.  So I have it set up that they can get the Labor cost totals they want for removing and adding - Having 3 parameters is the best way for them to play around I think for them to accomplish this.  There are several tables involved in the data behind and the amount they may want to add isn't connected to the table that populates the visual.

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        I did create Measures for Amount to be Removed and Amount to be Added.   So maybe there is way to use those measures in the visual measure based on which Report Period they choose - Would that be easier to figure out?

  • msalahkar's avatar
    msalahkar
    Frequent Visitor
    6 years ago

    Hi Anonymous 

     

    You need to create two filters - one for period and one for category. Than the user can choose around both of them to get desired result. Here is an example for it.

     

    total data

     now with filter

     

     I have only used one filter you can use two. Hope it help!!