Forum Discussion
Create a table with metrics
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 th...
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],...)
Summary Table = ADDCOLUMNS(VALUES(table[attribute]),”KPI 1”,[KPI 1 Measure],”KPI 2”,[KPI 2 Measure],...)