Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Create table from measure for visual

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 Sale...
Need Help
  • Arul's avatar
    Arul
    4 years ago

    Anonymous ,

     

    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

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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's avatar
Arul
Super User
4 years ago

Anonymous ,

 

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Thank you so much, Arul!