Get data to display in desired location in table and matrixes

[natabird3]

Hello,

I think rather stupid question for some of you but i am new to DAX and currently unable to come up with a function to solve the following problem. I want to display the following values in different rows not in the same one or in different columns but neither of the functions work for me. (i tried addnewcolumn but keeps giving me a scalar value error). 

All values are in the same table and i am simply trying to display it in a specific way but am unable to do that:

Ideally i would want to create the following dynamic visual:

Thanks in advance for the help.

[Nathaniel_C]

Hi @natabird3 ,

Not sure that I understand what you trying to do but could you not just drop measures in cards, and arrange as a table? or drop on a multi row card? You could turn off the category and put text box ob the bottom for the titles.
Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel

[natabird3]

I cannot do that because i will need to rank them and it needs to be dynamic. If i set them as cards its one value in the card and it will always stay on one place. However, i need to rank them based on the KPI selected. So that will not work, thanks for trying. 

[natabird3]

Anyone else know how to do this?