Measure: Percentage with multiple catgories

[11097486]

Hello, I'm tying to find a way to calculate percentages with multiple categories (see below) without using the option "show value as percentage". With this option, when we apply filters, the percentages change and I want them to stay the same.

I need a measure to do it but I can't find the solution.

Thank you

[11097486 · Accepted solution]

I used this measure and it worked. Thank you

Measure =  COUNT(Table1[Date])/CALCULATE(COUNT(Table1[Date]);ALL(Table1[Category]))

[mahoneypat]

You can use a measure like this to get your result.  Update it with your measure and the Month column used in your visual.

Pct All Months =
VAR vThisMonth = [Your Measure]
VAR vAllMonths =
    CALCULATE (
        [Your Measure],
        ALLSELECTED ( Date[Month] )
    )
RETURN
    DIVIDE (
        vThisMonth,
        vAllMonths
    )

Regards,

Pat