cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

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 the names of STU, REF and Δ and then build the table with dax?

 

I leave an image to better understand the problem:

 

Capture.PNG

 

Best regards. 

3 REPLIES 3
Seward12533 New Contributor
New Contributor

Re: Create a table with metrics

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

Re: Create a table with metrics

Hi @Anonymous

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

5.png

 

Best Regards

Maggie

Anonymous
Not applicable

Re: Create a table with metrics

Hi @v-juanli-msft,

 

 

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

Best Regards, 

 

Bruno. 

Helpful resources

Announcements
Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Power BI Helps Homeless and Trouble Youth

Power BI Helps Homeless and Trouble Youth

We spoke with Power BI Super User, Greg Deckler, about his charity work

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 39 members 987 guests
Please welcome our newest community members: