Create a table with metrics

Question

Hi,&nbsp;&nbsp;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?&nbsp;I leave an image to better understand the problem:&nbsp;&nbsp;Best regards.&nbsp;

seward12533 · Answer

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],...)

v-juanli-msft · Answer

Hi&nbsp;Anonymous
Does "&nbsp;STU, REF and Δ" exsit in the first table like the following picture?

&nbsp;
Best Regards
Maggie

anonymous · Answer

Hi&nbsp;v-juanli-msft,&nbsp;&nbsp;No :\, i've&nbsp;only the metrics and I'm connected to a tabular model.&nbsp;Best Regards,&nbsp;&nbsp;Bruno.&nbsp;

Forum Discussion

Create a table with metrics

3 Replies

Related content

Create new table

Lakehouse Table Generate Create Table

Create rows from 2 tables

Creating Date Tables

Fabric Capacity Metrics