Don't want recalculate with 100% bar chart

[Anonymous]

Hi Power BI Experts,

Is there a DAX formula to prevent the 100% bar chart from recalculating percentages if I exclude a category?

Here is my DAX. 

Knowledge % of Row Total =

DIVIDE(

COUNT('Progress Knowledge'[Knowledge Category] ) ,

CALCULATE(

COUNT('Progress Knowledge'[Knowledge Category] ) ,

REMOVEFILTERS('Progress Knowledge'[Knowledge Rating] , 'Progress Knowledge'[Progress Rating Scale],'Progress Knowledge'[Knowledge Category] )

) )

But if I exclude a percentage, the graph is recalculated.

I thought the Remove filters statement would prevent the recalculation but it does not. 

REMOVEFILTERS('Progress Knowledge'[Knowledge Rating] , 'Progress Knowledge'[Progress Rating Scale],'Progress Knowledge'[Knowledge Category] )

) )

Is the 100% bar chart the exception to the rule of RemoveFilters function?

Any nudge is greatly appreciated.

[Anonymous]

Hi @amitchandak ,

That is correct. Thank you.

[amitchandak · Accepted solution]

@Anonymous , 100% Stacked bar chart will calculate its own %. You can calculate % and use the Stacked bar visual, there removefilter, all , all except can help as per need

Divide([Meausre], calculate([Meausre], removefilter(Table, Table[Legend])) )