Forum Discussion

abukapsoun's avatar
abukapsoun
Post Patron
8 years ago
Solved

Create table from measures

Hi,   Is it possible to create a table out of measures? for example I have  Mea1 = 5 Mea2 = 4 Mea3 = 1   I want to create a bar visualisation to represent these value on a chart. How can I re...
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    8 years ago

    HI abukapsoun,


    For your scenario, you can try to use 'union' and 'row' functions.

    Sample:

    Table = 
UNION(ROW("Name","Measure1","Value",[Measure1]),ROW("Name","Measure2","Value",[Measure2]),ROW("Name","Measure3","Value",[Measure3]))

     

    Notice:

    1. Above formula not suitable to create a dynamic table. if you measure values are based filter/slicer, it will show the blank as the value.

    2. I haven't test on complex measures who contains specific filters and other conditions, so I'm not so sure if they can works on this formula.

    3. I also test with DATATABLE function, but it seem not support dynamic value and alert me to use static value.

     

    Regards,

    Xiaoxin Sheng

Jakub_Pabisiak's avatar
Jakub_Pabisiak
New Member
3 years ago

Hi,

 

how/when/where did you created the 

"NewTable"

 ?


  • Nathaniel_C's avatar
    Nathaniel_C
    Community Champion
    3 years ago

    Hi Jakub_Pabisiak ,
    A table can be created in Power BI or Power Query by using Enter Data. This is useful if you need to enter data, or in this case to create a table to answer a question here.


    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