DAX Formula - DIVIDE

[Anonymous]

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 

[amitchandak · Accepted solution]

@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)))

[Anonymous]

Thank you. I was using divide(sum(Table[value]), calculate(sum(Table[value]), allselected(Table))) but no results on filtering and that 1st one is perfect. Thank you