Measure with row

[Anonymous]

I have the follwoing table. In this table I have different type of values (total costs, cost per unit, percent).

In order to define the format of the specific information e.g. LTC. Backlight Unit = % and invest = full number, my idea was to create a measure for each of this category. I have programmed a measure and put this parameters into the values.

After this my table looked as following:

My question is how can I bring this table in the same format like at the first picture considering my measures. Perhaps I have to change my measures but how?

Would be very greatful if some could help.

[Anonymous]

I have forgot to add the code of the measures: 

(PI) Invest = CALCULATE(SUM('Anfügen1'[Info]),FILTER('Anfügen1','Anfügen1'[Item]="Invest"))

(PI) LTC Backlight Unit = CALCULATE(SUM('Anfügen1'[Info]),FILTER('Anfügen1','Anfügen1'[Item]="LTC: Backlight Unit"))

(PI) Mat. Cost: Backlight Unit = CALCULATE(SUM('Anfügen1'[Info]),FILTER('Anfügen1','Anfügen1'[Item]="Mat. Cost: Backlight Unit"))

[Icey · Accepted solution]

Hi @Anonymous ,

Try to create another measure like below and put it into your matrix.

Measure =
SWITCH (
    MAX ( 'YourTable'[Name] ),
    "Project Variant 1", [(PI) Invest],
    "Project Variant 2", [(PI) Mat. Cost. Backlight Unit],
    "Project Variant 3", [(PI) LTC Backlight Unit]
)

Best Regards,

Icey

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