Dynamic measures using parameters?

[Anonymous]

I would like change my measures based on a parameter

for example 


measure1 = DIVIDE(income;parameter)

parameter would be the column i selected for example in a slicer or filter. So parameter = tax or parameter = revenue depends on what i selected.

Would this be possible?

Thanks in advance!

[Anonymous]

I didn't know that this was possible in Power BI, but if I am understanding it right, it is possible to pick a slicer, and it would affect multiple measures/visuals across a report?

Example – Swap Measures Using Parameters - Tableau

I was thinking of the parameters features in Tableau, and it's much less clunky. Is there a workbook example of how Power BI does it?

[v-xuding-msft]

Hi @Anonymous ,

After creating parameters, a parameter table will be created. When you use it in the formulas, it can't be used directly in measures. You still need to use the function of SWITCH to change the value. So you don't have to create parameters. As amitchandak suggested, You could just create measures using SWITCH function to implement it.

Best Regards,

Xue Ding

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

[Anonymous]

My main purpose is to reduce the amount of measures that i have to create as i have make for example 100 measures which could maybe be reduced to 50 as it is almost the same forumula only with an other column

[v-xuding-msft]

Hi @Anonymous ,

Could you tell me if your problem has been solved? If it is, kindly mark the helpful answer as a solution if you feel that makes sense. Welcome to share your own solution. More people will benefit from here.

Best Regards,

Xue Ding

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

[v-xuding-msft]

Hi @Anonymous @Anonymous ,

For your requirement, it is not good choice for reducing the amount of measures to use parameters. It will use more measures and be more complicated. Using measures is easy and quick way for the situation.

You could try variables to combine and improve your formulas to reduce the amount of measures.

DAX: Use variables to improve your formulas 

Best Regards,

Xue Ding

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

[Anonymous]

I want to reduce the amount of measures that i need to create, I have two different columns which i use for almost all my measures
I thought would it be possible to make it "dynamic" or "filterable"?

So for example 

measure 1 = divide(gross ; revenue or profit)
measure 2 = divide (margin ; revenue or profit)

So i would like to just create 1 measure that divide either one of the columns profit or revenue depending on which one i choose.

woudl that be possible?

[amitchandak]

Refer this:

https://community.powerbi.com/t5/Desktop/Slicer-MTD-QTD-YTD-to-filter-dates-using-the-slicer/td-p/50...

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution.
In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blogs -Decoding Direct Query - Time Intelligence, Winner Coloring on MAP, HR Analytics, Power BI Working with Non-Standard TimeAnd Comparing Data Across Date Ranges
Proud to be a Datanaut Connect on Linkedin