CODEWITHSUNDEEP
powerbidaxpowerbi-desktoppowerbi-custom-visuals
ashish1780
ashish1780

Reputation: 47

Power BI- Call Percentage of Total based in a Filter

Trust you are well!

I'm calculating % of total by adding a new measure by this formula:-

FY21 Q1 ACTUAL = 
DIVIDE(
    SUM('Page1'[Q1 FY21]),
    CALCULATE(
        SUM('Page1'[Q1 FY21]),
        ALLSELECTED('Page1'[Domain])
    )
)

But when I'm applying filters to the "domain" then "FY21 Q1 ACTUAL" values are being changed. My goal is to keep the FY21 Q1 actual value as it is same even after applying "domain" level filter in another sheet/table. Currently it's giving % as "100%" when filter is applied by a particular domain name.

Please see the screengrab

enter image description here

Upvotes: 0

Views: 256

Answers (1)

mkRabbani
mkRabbani

Reputation: 16908

Try this below Measure-

FY21 Q1 ACTUAL = 
DIVIDE(
    SUM('Page1'[Q1 FY21]),
    CALCULATE(
        SUM('Page1'[Q1 FY21]),
        ALL('Page1'[Domain])
    )
)

Upvotes: 1

Related Questions