Forum Discussion
dbarseg1
2 years agoFrequent Visitor
Percentage and value data label for clustered column chart
Hi everyone, I'm new to DAX and writing measures. Below, I want the light blue and dark blue columns to show what percentage of their time cluster they account for. So for example, for 2019, the ...
- 2 years ago
try this measure
Hosp/PP % = DIVIDE( SUM('BSF Files'[12. Sum of Extended Price]), CALCULATE( SUM('BSF Files'[12. Sum of Extended Price]), ALLSELECTED('BSF Files'[08. Hosp/PP]) ), 0 )