How to group measures into categories

Hi, PetraM 

According to your description, you can try the following DAX to solve the problem. Using a matrix may be more relevant to what you are trying to accomplish.

DAX:

Actual = 
VAR _filter = SELECTEDVALUE('Table'[Category])
VAR _A_actual = CALCULATE(SUM('Table'[Value]),FILTER('Table','Table'[Category] = "A"))
VAR _B_actual = CALCULATE(SUM('Table'[Value]),FILTER('Table','Table'[Category] = "B"))
VAR _C_actual = CALCULATE(SUM('Table'[Value]),FILTER('Table','Table'[Category] = "C"))

RETURN
SWITCH(
    _filter,
    "A",_A_actual,
    "B",_B_actual,
    "C",_C_actual
)

target = 
VAR _filter = SELECTEDVALUE('Table'[Category])
VAR _A_Target = IF(SELECTEDVALUE('Table'[Category]) = "A",1000)
VAR _B_Target = IF(SELECTEDVALUE('Table'[Category]) = "B",1100)
VAR _C_Target = IF(SELECTEDVALUE('Table'[Category]) = "C",1200)
RETURN
SWITCH(
    _filter,
    "A",_A_Target,
    "B",_B_Target,
    "C",_C_Target
)


% VS Target = 

VAR _result = DIVIDE([Actual],[target])
RETURN
_result

Best Regards,
Yang
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