Percentage calculation

Thanks for the reply from Tahreem24, Kedar_Pande and nirali_arora, please allow me to provide another insight.
Hi trndlnd ,

I am not sure how your source data table is designed, below is my sample.

The source data table ( transformed in Power Query)

Creates the measure to be used to calculate the percentage of Red.

Percentage of red =
VAR total_for_each_area = COUNTROWS('Table')
VAR red_in_each_area = CALCULATE(COUNTROWS('Table'), 'Table'[Status] = "Red")
RETURN
DIVIDE(red_in_each_area,total_for_each_area)

Putting this measure in the matrix shows the percentage of red in each area. Hopefully this will meet your needs.

Please see the attached pbix for reference.

Best Regards,
Dengliang Li

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