graph show percentage base on data already filtering

[space83]

My graph show data based on value as below:

Is that possible for me to change the value to percentage based on filtering data?

I already did but grand total also count data that I already filtered.

The objective is when I sum every bar for every month, I will got result 100%

[v-henryk-mstf · Accepted solution]

Hi @space83 ,

According to your description, this can be done by creating MEASURE formulas. The key is to clear the external filtering context on the denominator with functions like all, allselect, etc.
Refer to the following test results.

Amount_filter = sum(FactInternetSales[SalesAmount])

Per_ =
VAR TotalAmountByColor =
    CALCULATE ( [Amount_filter], ALLSELECTED ( DimProduct[Color] ) )
RETURN
    DIVIDE ( [Amount_filter], TotalAmountByColor, BLANK () )

If the problem is still not resolved, please provide detailed error information and test data. Looking forward to your reply.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@space83 , You have to create a measure. Assume your current measure is m1

divide([M1], calculate([M1],  removefilters(Table[On Time]) ) )

Percent of SubTotal or Total: https://www.youtube.com/watch?v=6jTildcV2ho&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=37