Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Measure with row

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.

Need Help
  • Icey's avatar
    Icey
    4 years ago

    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.

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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's avatar
      Icey
      Community Support
      4 years ago

      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.