Forum Discussion
Dynamic measures using parameters?
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 parame...
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
Community Support
Community SupportHi 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.