Power Query Measure help

[TJI7746]

Hi All

Can someone help me update this formula so that whenever a filter/slicer is applied to the data, the percentages show are always out of 100%.

I have "White", "Ethnic Minority" and "Not Disclosed" under ethnicity grouped column, however, when i filter "Not Disclosed" out in the visual filers, the percentages shown still show out the 3 rather than the 2 displayed values. What am i doing wrong here?

Rating % =

DIVIDE(

    _Measures[Talent Rating ALL],

    CALCULATE(

        _Measures[Talent Rating ALL],

        ALLSELECTED('Talent Rating'[Ethnicity grouped])

    ),

    0

) * 100

[Anonymous]

Hi @TJI7746 ，

Could you provide the dax code for [Talent Rating ALL] and the filters that affect [Rating %]? Sample data and expected output would be great.
How to provide sample data in the Power BI Forum - Microsoft Fabric Community

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum 

[dharmendars007]

Hello @TJI7746 , 

Please try the below code where I ahve included the Ethnic group in Remove filter..

Rating % =
DIVIDE(
_Measures[Talent Rating ALL],
CALCULATE(
_Measures[Talent Rating ALL],
REMOVEFILTERS('Talent Rating'[Ethnicity grouped])),0) * 100

If you find this helpful , please mark it as solution which will be helpful for others and Your Kudos/Likes are much appreciated!

Thank You

Dharmendar S

LinkedIN 

[TJI7746]

I only want the values "White" and "Ethnic Minority" to be taken into account and the percentages to show out of this and not count "Not Disclosed"

[TJI7746]

Thanks for this however this did not work 😞