Forum Discussion

dbarseg1's avatar
dbarseg1
Frequent Visitor
2 years ago
Solved

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 ...
  • aduguid's avatar
    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
    )