topic Display data based on cell elements from one column in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Display-data-based-on-cell-elements-from-one-column/m-p/3635834#M140654 <P>Hello,&nbsp;</P><P>I have a dataset that has 8 columns&nbsp;</P><P>below is the sample data :</P><TABLE border="2"><TBODY><TR><TD><STRONG>code</STRONG></TD><TD><STRONG>MATRIXCDE</STRONG></TD><TD><STRONG>MATRIX</STRONG></TD><TD><STRONG>MATRIX_DESC</STRONG></TD><TD><STRONG>SUBGROUP</STRONG></TD><TD><STRONG>SUBGROUPNAME</STRONG></TD><TD><STRONG>PARAMETERCODE</STRONG></TD><TD><STRONG>PARAMETERNAME</STRONG></TD><TD><STRONG>TESTMETHOD</STRONG></TD></TR><TR><TD>100</TD><TD>1675</TD><TD>ADM</TD><TD>Admixture</TD><TD>Admixture (Civil)</TD><TD>Chemical</TD><TD>P123</TD><TD>xyz</TD><TD>site</TD></TR><TR><TD>100</TD><TD>1544</TD><TD>ADM</TD><TD>Admixture</TD><TD>Chemical</TD><TD>Chemical</TD><TD>P124</TD><TD>ghj</TD><TD>Visual</TD></TR><TR><TD>100</TD><TD>1675</TD><TD>ADM</TD><TD>Admixture</TD><TD>Admixture (Civil)</TD><TD>Chemical</TD><TD>P125</TD><TD>lkj</TD><TD>Visual</TD></TR><TR><TD>100</TD><TD>1</TD><TD>AIR</TD><TD>Air</TD><TD>MONITORING</TD><TD>Monitoring&nbsp;</TD><TD>P126</TD><TD>kl</TD><TD>Digital Meter</TD></TR><TR><TD>100</TD><TD>1</TD><TD>AIR</TD><TD>Air</TD><TD>MONITORING</TD><TD>Monitoring&nbsp;</TD><TD>P127</TD><TD>cl</TD><TD>Visual</TD></TR><TR><TD>100</TD><TD>1</TD><TD>AIR</TD><TD>Air</TD><TD>MONITORING</TD><TD>Monitoring&nbsp;</TD><TD>P128</TD><TD>cl</TD><TD>site</TD></TR><TR><TD>100</TD><TD>2849</TD><TD>ANF</TD><TD>ANIMAL FEED</TD><TD>METALS</TD><TD>Monitoring&nbsp;</TD><TD>P129</TD><TD>zn</TD><TD>Digital Meter</TD></TR><TR><TD>100</TD><TD>2849</TD><TD>ANF</TD><TD>ANIMAL FEED</TD><TD>METALS</TD><TD>METALS</TD><TD>P130</TD><TD>zn</TD><TD>Visual</TD></TR><TR><TD>100</TD><TD>2847</TD><TD>ANF</TD><TD>ANIMAL FEED</TD><TD>SUGAR PROFILE</TD><TD>SUGAR PROFILE</TD><TD>P131</TD><TD>fr</TD><TD>Visual</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>i want the data to be displayed for each <STRONG>MATRIX_DESC</STRONG>&nbsp;one after the other:</P><P>&nbsp;</P><P><STRONG>Admixture</STRONG></P><TABLE border="2"><TBODY><TR><TD><STRONG>PARAMETERCODE</STRONG></TD><TD><STRONG>PARAMETERNAME</STRONG></TD><TD><STRONG>TESTMETHOD</STRONG></TD></TR><TR><TD>P123</TD><TD>xyz</TD><TD>site</TD></TR><TR><TD>P124</TD><TD>ghj</TD><TD>Visual</TD></TR><TR><TD>P125</TD><TD>lkj</TD><TD>Visual</TD></TR></TBODY></TABLE><P>&nbsp;</P><P><STRONG>AIR</STRONG></P><TABLE border="2"><TBODY><TR><TD><STRONG>PARAMETERCODE</STRONG></TD><TD><STRONG>PARAMETERNAME</STRONG></TD><TD><STRONG>TESTMETHOD</STRONG></TD></TR><TR><TD>P126</TD><TD>kl</TD><TD>Digital Meter</TD></TR><TR><TD>P127</TD><TD>cl</TD><TD>Visual</TD></TR><TR><TD>P128</TD><TD>cl</TD><TD>site</TD></TR></TBODY></TABLE><P>&nbsp;</P><P><STRONG>ANIMAL FEED</STRONG></P><TABLE border="2"><TBODY><TR><TD><STRONG>PARAMETERCODE</STRONG></TD><TD><STRONG>PARAMETERNAME</STRONG></TD><TD><STRONG>TESTMETHOD</STRONG></TD></TR><TR><TD>P129</TD><TD>zn</TD><TD>Digital Meter</TD></TR><TR><TD>P130</TD><TD>zn</TD><TD>Visual</TD></TR><TR><TD>P131</TD><TD>fr</TD><TD>Visual</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>How&nbsp; can i achieve this format ? i have tried grouping the data by <STRONG>MATRIX_DESC&nbsp;</STRONG>but still cant display it.&nbsp;</P> Fri, 12 Jan 2024 13:57:49 GMT user_bi 2024-01-12T13:57:49Z Display data based on cell elements from one column https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Display-data-based-on-cell-elements-from-one-column/m-p/3635834#M140654 <P>Hello,&nbsp;</P><P>I have a dataset that has 8 columns&nbsp;</P><P>below is the sample data :</P><TABLE border="2"><TBODY><TR><TD><STRONG>code</STRONG></TD><TD><STRONG>MATRIXCDE</STRONG></TD><TD><STRONG>MATRIX</STRONG></TD><TD><STRONG>MATRIX_DESC</STRONG></TD><TD><STRONG>SUBGROUP</STRONG></TD><TD><STRONG>SUBGROUPNAME</STRONG></TD><TD><STRONG>PARAMETERCODE</STRONG></TD><TD><STRONG>PARAMETERNAME</STRONG></TD><TD><STRONG>TESTMETHOD</STRONG></TD></TR><TR><TD>100</TD><TD>1675</TD><TD>ADM</TD><TD>Admixture</TD><TD>Admixture (Civil)</TD><TD>Chemical</TD><TD>P123</TD><TD>xyz</TD><TD>site</TD></TR><TR><TD>100</TD><TD>1544</TD><TD>ADM</TD><TD>Admixture</TD><TD>Chemical</TD><TD>Chemical</TD><TD>P124</TD><TD>ghj</TD><TD>Visual</TD></TR><TR><TD>100</TD><TD>1675</TD><TD>ADM</TD><TD>Admixture</TD><TD>Admixture (Civil)</TD><TD>Chemical</TD><TD>P125</TD><TD>lkj</TD><TD>Visual</TD></TR><TR><TD>100</TD><TD>1</TD><TD>AIR</TD><TD>Air</TD><TD>MONITORING</TD><TD>Monitoring&nbsp;</TD><TD>P126</TD><TD>kl</TD><TD>Digital Meter</TD></TR><TR><TD>100</TD><TD>1</TD><TD>AIR</TD><TD>Air</TD><TD>MONITORING</TD><TD>Monitoring&nbsp;</TD><TD>P127</TD><TD>cl</TD><TD>Visual</TD></TR><TR><TD>100</TD><TD>1</TD><TD>AIR</TD><TD>Air</TD><TD>MONITORING</TD><TD>Monitoring&nbsp;</TD><TD>P128</TD><TD>cl</TD><TD>site</TD></TR><TR><TD>100</TD><TD>2849</TD><TD>ANF</TD><TD>ANIMAL FEED</TD><TD>METALS</TD><TD>Monitoring&nbsp;</TD><TD>P129</TD><TD>zn</TD><TD>Digital Meter</TD></TR><TR><TD>100</TD><TD>2849</TD><TD>ANF</TD><TD>ANIMAL FEED</TD><TD>METALS</TD><TD>METALS</TD><TD>P130</TD><TD>zn</TD><TD>Visual</TD></TR><TR><TD>100</TD><TD>2847</TD><TD>ANF</TD><TD>ANIMAL FEED</TD><TD>SUGAR PROFILE</TD><TD>SUGAR PROFILE</TD><TD>P131</TD><TD>fr</TD><TD>Visual</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>i want the data to be displayed for each <STRONG>MATRIX_DESC</STRONG>&nbsp;one after the other:</P><P>&nbsp;</P><P><STRONG>Admixture</STRONG></P><TABLE border="2"><TBODY><TR><TD><STRONG>PARAMETERCODE</STRONG></TD><TD><STRONG>PARAMETERNAME</STRONG></TD><TD><STRONG>TESTMETHOD</STRONG></TD></TR><TR><TD>P123</TD><TD>xyz</TD><TD>site</TD></TR><TR><TD>P124</TD><TD>ghj</TD><TD>Visual</TD></TR><TR><TD>P125</TD><TD>lkj</TD><TD>Visual</TD></TR></TBODY></TABLE><P>&nbsp;</P><P><STRONG>AIR</STRONG></P><TABLE border="2"><TBODY><TR><TD><STRONG>PARAMETERCODE</STRONG></TD><TD><STRONG>PARAMETERNAME</STRONG></TD><TD><STRONG>TESTMETHOD</STRONG></TD></TR><TR><TD>P126</TD><TD>kl</TD><TD>Digital Meter</TD></TR><TR><TD>P127</TD><TD>cl</TD><TD>Visual</TD></TR><TR><TD>P128</TD><TD>cl</TD><TD>site</TD></TR></TBODY></TABLE><P>&nbsp;</P><P><STRONG>ANIMAL FEED</STRONG></P><TABLE border="2"><TBODY><TR><TD><STRONG>PARAMETERCODE</STRONG></TD><TD><STRONG>PARAMETERNAME</STRONG></TD><TD><STRONG>TESTMETHOD</STRONG></TD></TR><TR><TD>P129</TD><TD>zn</TD><TD>Digital Meter</TD></TR><TR><TD>P130</TD><TD>zn</TD><TD>Visual</TD></TR><TR><TD>P131</TD><TD>fr</TD><TD>Visual</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>How&nbsp; can i achieve this format ? i have tried grouping the data by <STRONG>MATRIX_DESC&nbsp;</STRONG>but still cant display it.&nbsp;</P> Fri, 12 Jan 2024 13:57:49 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Display-data-based-on-cell-elements-from-one-column/m-p/3635834#M140654 user_bi 2024-01-12T13:57:49Z Re: Display data based on cell elements from one column https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Display-data-based-on-cell-elements-from-one-column/m-p/3638022#M140796 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="639822" data-lia-user-login="user_bi" class="lia-mention lia-mention-user">user_bi</a>&nbsp;,</P> <P>&nbsp;</P> <P>Based on the sample and description you provided, Please try the following steps:</P> <P>1.In the Power Query Editor，click on 'Group By' on the Transform tab.</P> <P><img /></P> <P><img /></P> <P>2. Please Right-click on the table cell and select Add as New Query. You can rename the new query as needed.</P> <P><img /></P> <P><img /></P> <P>Next you can remove unnecessary columns as needed.</P> <P><img /></P> <P>Result is as below.</P> <P><img /></P> <P>In addition， you can also consider using the dax as follows.</P> <LI-CODE lang="markup">AdmixtureTable = FILTER('Table2','Table2'[MATRIX_DESC] = "Admixture")</LI-CODE> <P>Result is as below.</P> <P><img /></P> <P>&nbsp;</P> <P>For further details，please find attachment.</P> <P>&nbsp;</P> <P>Best Regards,<BR />Yulia Yan<BR /><BR />If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.</P> Mon, 15 Jan 2024 02:36:00 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Display-data-based-on-cell-elements-from-one-column/m-p/3638022#M140796 v-weiyan1-msft 2024-01-15T02:36:00Z Re: Display data based on cell elements from one column https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Display-data-based-on-cell-elements-from-one-column/m-p/3638181#M140808 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="652678" data-lia-user-login="v-weiyan1-msft" class="lia-mention lia-mention-user">v-weiyan1-msft</a>&nbsp;</P><P>&nbsp;</P><P>This sample contains only 3 different Matrix_desc but the original dataset has 200+, is there a better way to execute the above for 200+ parameters as grouping them individually would be very time consuming.</P><P>&nbsp;</P><P>Thank you in advance&nbsp;&nbsp;</P> Mon, 15 Jan 2024 05:52:07 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Display-data-based-on-cell-elements-from-one-column/m-p/3638181#M140808 user_bi 2024-01-15T05:52:07Z