Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Combine measures as columns in a new table

Hi datanuts, I've done some sector benchmarking across regions and various metrics (employment, value added, productivity, growth, etc) manually as a proof of concept and now trying to scale it using DAX and Radar chart.

My source table, intermediate table, and final visual (to be filtered by sector) done manually are attached.

I've created measures which calculate MIN, MAX, our position (D2N2), and a normalised score for each metric but having trouble getting the intemediate table using UNION, SELECTCOLUMS, CALCULATETABLE, GROUPBY/SUMMARIZE. 

Any advice of how to tackle this problem would be much appreciated. @danextian;@TomMartens; @v-huizhn-msft

Thank you,

V.data1.PNGData tableresult table.PNGIntermediate table with metrics I want to plot as rows and measures as columnsresult viz.PNGfinal viz

Helpful resources

Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

‘Better Together’ Integration Forum Launch

‘Better Together’ Integration Forum Launch

We've launched a how-to forum where you can learn about how Power BI integrates with other Power Platform products.