How to create a cross table with measures?

Question

Hello,&nbsp;I have two tables : Revenue &amp; Sales which has numbers at a quarterly level by Geo. In both tables, I have calculated measures for Total, Q/Q Change &amp; Y/Y Change. How do I create a new table which has the measures as rows and the calculations as Columns for e.g.&nbsp;Measure&nbsp; &nbsp; &nbsp;Geo&nbsp; &nbsp; &nbsp; &nbsp; Total&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Q/Q Change&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Y/Y ChangeRevenue&nbsp; &nbsp; &nbsp;APAC&nbsp; &nbsp; &nbsp; &nbsp; 100&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 10%&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 17%Revenue&nbsp; &nbsp; &nbsp;NA&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 100&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 15%&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 21%Revenue&nbsp; &nbsp; &nbsp;WW&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 200&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 12%&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 19%Sales&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; APAC&nbsp; &nbsp; &nbsp; &nbsp; 150&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 10%&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 17%Sales&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; NA&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 180&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 15%&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 21%Sales&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; WW&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 225&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 12%&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 19%&nbsp;Will measure tables help? Please advise

v-deddai1-msft · Accepted Answer

Hi&nbsp;EshaanG&nbsp;,&nbsp;You can use the below calculated column:Table = UNION(ROW("Type","Revenue","Total",[Total for Revenue],"Q/Q Change",[Q/Q Change for Revenue],"Y/Y Change",[Y/Y Change for Revenue]),ROW("Type","Sales","Total",[Total for Sales],"Q/Q Change",[Q/Q Change for Sales],"Y/Y Change",[Y/Y Change for Sales]))&nbsp;If this post&nbsp;helps, then please consider&nbsp;Accept it as the solution&nbsp;to help the other members find it more quickly.&nbsp;Best Regards,Dedmon Dai

Forum Discussion

How to create a cross table with measures?

2 Replies

Related content

Need help creating a measure

Help to create DAX Measure

Cross highlighting measure

Cross datawarehouse queries

Cross workspace semantic model access