make a table by using matrix

Question

How to extract the data completely from the matrix visual in a tabular form. So that I can use that summarise data in any form for lookup and other things dynamically.
The outputs are showing from measures.

tahreem24 · Answer

Arghya_Dutta&nbsp; Could you explain with the help of screen shots or dummy data?
&nbsp;
&nbsp;

danextian · Answer

Hi Arghya_Dutta&nbsp;
Matrix visual and any other viz will export data of whatever field/measurs are added to it. So if you select only a few dimensions and a few measures , you'll get just those dimensions and measures. If you want the complete underlying data, all the dimensions and measures must be complely present in the viz.

bibiano_geraldo · Answer

Hi&nbsp;Arghya_Dutta&nbsp;,Please provide more details, extract for where?

anonymous · Answer

Hi&nbsp;Arghya_Dutta&nbsp;
&nbsp;
You can export the data from the matrix visual, here for your reference:
Export data from a Power BI visualization - Power BI | Microsoft Learn

&nbsp;
Once you have exported the data to Excel, you can use it for lookup and other dynamic purposes. You can further manipulate the data in Excel or import it back into Power BI for additional analysis.
&nbsp;
Best Regards
Zhengdong XuIf this post&nbsp;helps, then please consider&nbsp;Accept it as the solution&nbsp;to help the other members find it more quickly.

arghya_dutta · Answer

I have a matrix from my Part Wise CS table In which&nbsp;Rows Contains1. Part Number&nbsp;2. Part NameColumns Contains:MonthValues ContainsQtySTDV ---------------Its a measureAvg.-----------------Its a measureCheck---------------Its a measurethis is my check measureCheck =&nbsp;value&nbsp;( (CALCULATE(STDEV.P('Part Wise CS'[Qty]),'Part Wise CS'[Month]&lt;&gt;SWITCH(&nbsp; &nbsp;&nbsp;MONTH(MAX(Calender[Date])),&nbsp; &nbsp;&nbsp;1,&nbsp;"January",&nbsp; &nbsp;&nbsp;2,&nbsp;"February",&nbsp; &nbsp;&nbsp;3,&nbsp;"March",&nbsp; &nbsp;&nbsp;4,&nbsp;"April",&nbsp; &nbsp;&nbsp;5,&nbsp;"May",&nbsp; &nbsp;&nbsp;6,&nbsp;"June",&nbsp; &nbsp;&nbsp;7,&nbsp;"July",&nbsp; &nbsp;&nbsp;8,&nbsp;"August",&nbsp; &nbsp;&nbsp;9,&nbsp;"September",&nbsp; &nbsp;&nbsp;10,&nbsp;"October",&nbsp; &nbsp;&nbsp;11,&nbsp;"November",&nbsp; &nbsp;&nbsp;12,&nbsp;"December")) +&nbsp;CALCULATE(AVERAGE('Part Wise CS'[Qty]),'Part Wise CS'[Month]&lt;&gt;SWITCH(&nbsp; &nbsp;&nbsp;MONTH(MAX(Calender[Date])),&nbsp; &nbsp;&nbsp;1,&nbsp;"January",&nbsp; &nbsp;&nbsp;2,&nbsp;"February",&nbsp; &nbsp;&nbsp;3,&nbsp;"March",&nbsp; &nbsp;&nbsp;4,&nbsp;"April",&nbsp; &nbsp;&nbsp;5,&nbsp;"May",&nbsp; &nbsp;&nbsp;6,&nbsp;"June",&nbsp; &nbsp;&nbsp;7,&nbsp;"July",&nbsp; &nbsp;&nbsp;8,&nbsp;"August",&nbsp; &nbsp;&nbsp;9,&nbsp;"September",&nbsp; &nbsp;&nbsp;10,&nbsp;"October",&nbsp; &nbsp;&nbsp;11,&nbsp;"November",&nbsp; &nbsp;&nbsp;12,&nbsp;"December")))*0.3&nbsp;+CALCULATE(STDEV.P('Part Wise CS'[Qty]),'Part Wise CS'[Month]&lt;&gt;SWITCH(&nbsp; &nbsp;&nbsp;MONTH(MAX(Calender[Date])),&nbsp; &nbsp;&nbsp;1,&nbsp;"January",&nbsp; &nbsp;&nbsp;2,&nbsp;"February",&nbsp; &nbsp;&nbsp;3,&nbsp;"March",&nbsp; &nbsp;&nbsp;4,&nbsp;"April",&nbsp; &nbsp;&nbsp;5,&nbsp;"May",&nbsp; &nbsp;&nbsp;6,&nbsp;"June",&nbsp; &nbsp;&nbsp;7,&nbsp;"July",&nbsp; &nbsp;&nbsp;8,&nbsp;"August",&nbsp; &nbsp;&nbsp;9,&nbsp;"September",&nbsp; &nbsp;&nbsp;10,&nbsp;"October",&nbsp; &nbsp;&nbsp;11,&nbsp;"November",&nbsp; &nbsp;&nbsp;12,&nbsp;"December")) +&nbsp;CALCULATE(AVERAGE('Part Wise CS'[Qty]),'Part Wise CS'[Month]&lt;&gt;SWITCH(&nbsp; &nbsp;&nbsp;MONTH(MAX(Calender[Date])),&nbsp; &nbsp;&nbsp;1,&nbsp;"January",&nbsp; &nbsp;&nbsp;2,&nbsp;"February",&nbsp; &nbsp;&nbsp;3,&nbsp;"March",&nbsp; &nbsp;&nbsp;4,&nbsp;"April",&nbsp; &nbsp;&nbsp;5,&nbsp;"May",&nbsp; &nbsp;&nbsp;6,&nbsp;"June",&nbsp; &nbsp;&nbsp;7,&nbsp;"July",&nbsp; &nbsp;&nbsp;8,&nbsp;"August",&nbsp; &nbsp;&nbsp;9,&nbsp;"September",&nbsp; &nbsp;&nbsp;10,&nbsp;"October",&nbsp; &nbsp;&nbsp;11,&nbsp;"November",&nbsp; &nbsp;&nbsp;12,&nbsp;"December"))-CALCULATE(SUM('Part Wise CS'[Qty]),'Part Wise CS'[Month]=SWITCH(&nbsp; &nbsp;&nbsp;MONTH(MAX(Calender[Date])),&nbsp; &nbsp;&nbsp;1,&nbsp;"January",&nbsp; &nbsp;&nbsp;2,&nbsp;"February",&nbsp; &nbsp;&nbsp;3,&nbsp;"March",&nbsp; &nbsp;&nbsp;4,&nbsp;"April",&nbsp; &nbsp;&nbsp;5,&nbsp;"May",&nbsp; &nbsp;&nbsp;6,&nbsp;"June",&nbsp; &nbsp;&nbsp;7,&nbsp;"July",&nbsp; &nbsp;&nbsp;8,&nbsp;"August",&nbsp; &nbsp;&nbsp;9,&nbsp;"September",&nbsp; &nbsp;&nbsp;10,&nbsp;"October",&nbsp; &nbsp;&nbsp;11,&nbsp;"November",&nbsp; &nbsp;&nbsp;12,&nbsp;"December")))This is my STDV measureSTDV =VAR&nbsp;LatestMonth&nbsp;=&nbsp; &nbsp;&nbsp;SWITCH(&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;MONTH(MAX('Calender'[Date])),&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;1,&nbsp;"January",&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;2,&nbsp;"February",&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;3,&nbsp;"March",&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;4,&nbsp;"April",&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;5,&nbsp;"May",&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;6,&nbsp;"June",&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;7,&nbsp;"July",&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;8,&nbsp;"August",&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;9,&nbsp;"September",&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;10,&nbsp;"October",&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;11,&nbsp;"November",&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;12,&nbsp;"December"&nbsp; &nbsp; )VAR&nbsp;ValidRows&nbsp;=&nbsp; &nbsp;&nbsp;FILTER(&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;'Part Wise CS',&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;'Part Wise CS'[CSD_PNO]&nbsp;=&nbsp;MAX('Part Wise CS'[CSD_PNO])&nbsp; &nbsp; )VAR&nbsp;DataExcludingLatestMonth&nbsp;=&nbsp; &nbsp;&nbsp;FILTER(&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;ValidRows,&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;'Part Wise CS'[Month]&nbsp;&lt;&gt;&nbsp;LatestMonth&nbsp; &nbsp; )VAR&nbsp;Result&nbsp;=&nbsp; &nbsp;&nbsp;CALCULATE(&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;STDEV.P('Part Wise CS'[Qty]),&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;DataExcludingLatestMonth&nbsp; &nbsp; )RETURNIF(&nbsp; &nbsp;&nbsp;COUNTROWS(DataExcludingLatestMonth) &gt;&nbsp;1,&nbsp; &nbsp;&nbsp;Result,&nbsp; &nbsp;&nbsp;BLANK())This is my Avg. measureAvg.&nbsp;=&nbsp;CALCULATE(AVERAGE('Part Wise CS'[Qty]),'Part Wise CS'[Month]&lt;&gt;SWITCH(&nbsp; &nbsp;&nbsp;MONTH(MAX(Calender[Date])),&nbsp; &nbsp;&nbsp;1,&nbsp;"January",&nbsp; &nbsp;&nbsp;2,&nbsp;"February",&nbsp; &nbsp;&nbsp;3,&nbsp;"March",&nbsp; &nbsp;&nbsp;4,&nbsp;"April",&nbsp; &nbsp;&nbsp;5,&nbsp;"May",&nbsp; &nbsp;&nbsp;6,&nbsp;"June",&nbsp; &nbsp;&nbsp;7,&nbsp;"July",&nbsp; &nbsp;&nbsp;8,&nbsp;"August",&nbsp; &nbsp;&nbsp;9,&nbsp;"September",&nbsp; &nbsp;&nbsp;10,&nbsp;"October",&nbsp; &nbsp;&nbsp;11,&nbsp;"November",&nbsp; &nbsp;&nbsp;12,&nbsp;"December"))The measures changes there values as per my selected months from Slicer of Month. this month is from Calender Table.&nbsp;The Part wise CS and Calender table is connected through a common column which is concatenate.&nbsp;Now in matrix visual I am getting part number, part name, Avg., Stdv and CheckI want to capture that Check values which is actually Rows total against each Part number which should be dynamically. So That I can use that check measures values against each part number as per selected slicer for look up with other table.

Forum Discussion

make a table by using matrix

5 Replies

Related content

Matrix table

PowerBI - Matrix table, hide values used only for a visual calculation

Matrix table

KPI level matrix table

Matrix table in Power bi