Forum Discussion

v-xuding-msft's avatar
v-xuding-msft
Community Support
6 years ago

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's avatar
Anonymous
Not applicable
6 years ago

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?