Forum Discussion
How to calculate a division without using DAX
This is a short example of the development created for a specific requirement.
The idea is to have only one measure that provides all the results for the crucial metrics. Everything has been working as expected. (Measure = SUM('Values'[Value])).
However, the client is requesting a new metric that involves a division between two previous results, but with a specific condition: It is not allowed two use DAX for this calculation. The goal is to have this result also contained on the measure used until now. In this example Metric E.
I have been searching for a possible solution, but so far, anything seems to be useful for this purpose. I haven't found a way to calculate this division of calculated results using Power Query or implementing another alternative.
Is there a way to get this result to include it in the global measure?
Regards.
1 Reply
- amitchandakSuper User
Anonymous , if you have already created measures and you wanted to have DAX division. M in EditQuery will only enable new columns. and calculations on it.
Measure calculation is done at run time and ratios should always be measures. If you do not want to divide, who can you get that calculation otherwise?
Refer, if this can give you more pointers