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

Anonymous's avatar
Anonymous
Not applicable
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

jatneerjat's avatar
jatneerjat
Helper V
8 years ago

Hi Anonymous,

 

You mean we cant use measures whose values are changing dynamically?

 

Thanks,

Jat