Power bi

Hi PMEH ,

First of all, many thanks to  for your very quick and effective replies.

Based on my testing, please try the following methods:

1.Create the simple table.

2.Create the new measure to calculate the percentage.

Add pen = 
VAR hp_ = SUMX('Table', 'Table'[Total hp])
VAR hpa = SUMX('Table', 'Table'[Total hp agg])
RETURN
DIVIDE(hp_, hpa)

3.Create the measure to filter the percentage.

Percentage = 
SWITCH(
        TRUE(),
        [Add pen] <= 0.1, "0%-10%",
        [Add pen] <= 0.2, "11%-20%",
        [Add pen] <= 0.3, "21%-30%",
        [Add pen] <= 0.4, "31%-40%",
        [Add pen] <= 0.5, "41%-50%",
        "51%+"
    )

4.Drag the measure into the table visual. The result is shown below.

Best Regards,

Wisdom Wu

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