Forum Discussion
DAX Formula - DIVIDE
Hello,
I need some help with some formula that I can't put in a right way.
I need to have the participation of all categories for sales. I did the DAX formula in the right way for a table without filters. But on the visualizations, when I filter the calculation is not doing the right values.
example:
Water 1000
Wine 2000
Bread 1000
Milk 1500
total 5500
My calculation is dividing for water participation 1000/5500, wine participation 2000/5500... but when I put on the visualizations and filtering with one category to see evolution of the participation the result appears 100%
Can you help me?
Thank you
Anonymous , Try one of the two measures
divide(sum(Table[value]), calculate(sum(Table[value]), all(Table)))
divide(sum(Table[value]), calculate(sum(Table[value]), allselected(Table)))
2 Replies
Anonymous , Try one of the two measures
divide(sum(Table[value]), calculate(sum(Table[value]), all(Table)))
divide(sum(Table[value]), calculate(sum(Table[value]), allselected(Table)))