Keep Calculate % of NEW Grand Total after Filtering

[chaichatp]

What I got after filtering NAME Column was that the % Total will be deducted from the row I filtered in Power BI Report. Is it possible to do what I attached. Thanks.

 

[v-jiascu-msft · Accepted solution]

Hi @chaichatp,

Please try out these two measures.

% of Grand Total =
DIVIDE (
    SUM ( Table1[Quantity] ),
    CALCULATE ( SUM ( Table1[Quantity] ), ALLSELECTED ( Table1[Name] ) ),
    0
)

%GrandTotal*Score =
IF (
    HASONEVALUE ( Table1[Name] ),
    [% of Grand Total] * MIN ( Table1[Score] ),
    SUMX (
        SUMMARIZE (
            'Table1',
            Table1[Name],
            "score", [% of Grand Total] * MIN ( 'Table1'[Score] )
        ),
        [score]
    )
)

Best Regards,

Dale

[chaichatp]

Wowww. That looks like what I was looking for. Thanks so much.