Create a table with metrics

[Anonymous]

Hi, 

I have some metrics created for KPIs, and I want to create a table to contain metric values (KPIs). I need to create a disconnected table with the names of the KPIs and another table with the names of STU, REF and Δ and then build the table with dax?

I leave an image to better understand the problem:

Best regards. 

[v-juanli-msft]

Hi @Anonymous

Does " STU, REF and Δ" exsit in the first table like the following picture?

Best Regards

Maggie

[Anonymous]

Hi @v-juanli-msft,

No :\, i've only the metrics and I'm connected to a tabular model. 

Best Regards, 

Bruno. 

[Seward12533]

That is the basic approach. Assuming you have the measures defined. Something like this DAX will calculate a table

Summary Table = ADDCOLUMNS(VALUES(table[attribute]),”KPI 1”,[KPI 1 Measure],”KPI 2”,[KPI 2 Measure],...)