Create table from measure for visual

[Kandidel]

Hi communitiy,

I would need to create a new table for a visual. Should look like below. Value should result from several measures.  How can I do this? Please help.

Item	Value
External Sales
Commercial Margin
Indirect Cost
Total Margin
Department Cost
R&D Cost
Contribution Margin

Thanks a lot!

[Arul]

@Kandidel ,

Create a table and measure as like the below and use it in the visual,

Thanks,

Arul

[amitchandak]

@Kandidel , In a matrix  use show on row

https://docs.microsoft.com/en-us/power-bi/visuals/desktop-matrix-visual

Or use calculation groups

Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display : https://youtu.be/qMNv67P8Go0

[Kandidel]

@amitchandak  and @Arul , thank you both for your quick replies. Unfortunately not the solution. I need this data table created. The measure used will be a waterfall chart based on the cretaed table.

I can get the doble done with dax, but only with the measures in columns, not in rows.  Any ideas?

Thank you.

[Arul · Accepted solution]

@Kandidel ,

you may try to create table by enter data feature to insert "Item" manually and then create calculated column for the value (include all of your measures in a calculation).

Thanks,

Arul

[Kandidel]

Thank you so much, Arul!