DAX measure for Share of Total
Hi, I am not new to DAX and this is a very simple measure, but for some reason it does not work this time. I want to calculate to the share of total for every category. The measure: Customer rating Share of Total (%) = DIVIDE( [Customer rating count], CALCULATE( [Customer rating count], ALL('Customer Rating'[Rating]) ) ) Output: For my own sanity I tried it for a different measure, because I know this should work. Measure: DELETE Share of Turnover = DIVIDE( [DELETE TEST Turnover], CALCULATE( [DELETE TEST Turnover], ALL('Product Category'[Product category]) ) ) Output: As you can see, the measure is basically the same and it works. Sometimes DAX drives me crazy with it's inconsistencies, can someone please explain why it does not work in the first example? Thanks
