Calculated row in Matrix based on another Matrix

[Minseven07]

I am encountering an issue in Power BI where I am unable to display custom row titles in the Rows section of a matrix table.

Looks easy to achieve but i'm really struggling with this one....

I want to have a similar table (Ratio Matrix):

Then what I have achieved so far:

i have created a New Measure (not sure if this is the right method)

Ratio_1 =
CALCULATE (
    SUM ( '2023'[ETP] ),
    '2023'[Schools] IN {"School 6", "School 4"}
) / SUM ( '2023'[ETP] )P] )

Even if the calculated ratio are correct, there is no way to have "Ratio 1" in a row title.

Regards

[Minseven07 · Accepted solution]

Ok i found the reason - it is because i need to add more than one measure and the name appears => That's WEIRD! 😄

https://community.fabric.microsoft.com/t5/Desktop/Show-on-rows-not-working/td-p/1004849

[Minseven07]

by the way, i tried the solution to "Switch values to row" but it didn't helped (nothing happens)