A table of measures

[khaledbou]

Hello, I have a few measures that I created .. I want to create a table where it have the following columns: 'measure name', 'measure importances' .. other measure metadata of the measures (add them manually)  and a column where it contains the value of the measure.

is there any way to archive that? and is it possible to make it dynamic as if the measure value changes the value in the table will also change. thank you 

[vojtechsima · Accepted solution]

Hello, @khaledbou 
In latest version of PBI Desktop in DAX Query you can do this:

However, you cannot use this to create a physical table. One workaround that could perhaps work is to send this query through Power Automate using Send Query against Dataset (or something like that) and then save that result on sharepoint and then back to Power BI.

the Description (you can use that for priority) and you can do that in Model

[khaledbou]

thank you for your answer! very insightful

[Anonymous · Accepted solution]

Hi @khaledbou ,

Agree with @vojtechsima , in Power BI, any entity table created with DAX cannot be dynamic, and the measures you created cannot be obtained dynamically.
For your needs, I think the best way is to manually create and update the record table. You can also try to use Power Automate as mentioned by vojtechsima, but that may have requirements for your data source. You can go to the Power Automate forum to ask whether your expected results can be achieved.
Microsoft Power Platform Community Forum Thread

Best Regards,
Dino Tao

[khaledbou]

hello @Anonymous  .. thanks for responding .. i'll try the work around of @vojtechsima  seems worth the try. 

[vojtechsima · Accepted solution]

Hello, @khaledbou 
In latest version of PBI Desktop in DAX Query you can do this:

However, you cannot use this to create a physical table. One workaround that could perhaps work is to send this query through Power Automate using Send Query against Dataset (or something like that) and then save that result on sharepoint and then back to Power BI.

the Description (you can use that for priority) and you can do that in Model