Parameters in Measures with Multiple Conditions

[Anonymous]

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

[msalahkar]

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

[MFelix]

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]

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]

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?

[dax]

Hi @Anonymous , 

You said that you want to "show measure in visual  based on which Report Period they choose", what is relationship betweem measures and report period? If possible could you please inform me more detailed information(such as your expected output and your sample data (by OneDrive for Business))? Then I will help you more correctly.

Please do mask sensitive data before uploading.

Thanks for your understanding and support.
Best Regards,
Zoe Zhi

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

[Anonymous]

Sorry - I may not have been clear.  I don't want to filter the visuals, I want to change the calculations that drive that visual through parameters or other alternatives.   

I am not allowed to upload anything to the site and our data model is fairly complex to try to show a sampling of demo data would be difficult.   I am afraid I may be looking for a solution that doesn't exist at in Power Bi at this time.

Thanks all for the input.

[MFelix]

Hi  @Anonymous 

What you are trying to achieve is to have for example:

• Salary is 400K and is 40% of your total costs (1M)
• Slicer with value to remove 100K to Salary
• Slicer with value to add an increase of 10% also in salary
• So the final result would be:
  • Salary 330K
  • Total costs 930 (1M -100K + 30K)
  • Percentage of salary is 35% previously 40%

Is this the result you need to calculate?

[Anonymous · Accepted solution]

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!