topic Re: Create custom filtered table in DAX Commands and Tips

topic Re: Create custom filtered table in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Create-custom-filtered-table/m-p/3240570#M119216 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="379060" data-lia-user-login="Wirestat" class="lia-mention lia-mention-user">Wirestat</a> , Create a matrix visual and use desc in column.</P> <P> </P> <P>If you need a calculated(data) table. Pivot in power query -</P> <P>Pivot Data(Power Query) :<A href="https://www.youtube.com/watch?v=oKByyI09Bno&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=12" target="_blank">https://www.youtube.com/watch?v=oKByyI09Bno&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=12</A></P> Wed, 17 May 2023 15:20:58 GMT amitchandak 2023-05-17T15:20:58Z Create custom filtered table https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Create-custom-filtered-table/m-p/3240416#M119204 <P>Hello, I have a table with tree columns </P><TABLE><TBODY><TR><TD>no</TD><TD>desc</TD><TD>act</TD></TR><TR><TD>1558957</TD><TD>SA1</TD><TD>29656</TD></TR><TR><TD>1558957</TD><TD>SA1</TD><TD>22396</TD></TR><TR><TD>1560476</TD><TD>SA1</TD><TD>6789</TD></TR><TR><TD>1559200</TD><TD>SA1</TD><TD>61206</TD></TR><TR><TD>1559691</TD><TD>SA2</TD><TD>53429</TD></TR><TR><TD>1558958</TD><TD>SA2</TD><TD>56887</TD></TR><TR><TD>1558958</TD><TD>SA2</TD><TD>50926</TD></TR><TR><TD>1558958</TD><TD>SA2</TD><TD>50778</TD></TR><TR><TD>1559694</TD><TD>SA3</TD><TD>59725</TD></TR><TR><TD>1559692</TD><TD>SA3</TD><TD>57488</TD></TR><TR><TD>1560573</TD><TD>SA3</TD><TD>8300</TD></TR><TR><TD>1551588</TD><TD>SA3</TD><TD>59723</TD></TR><TR><TD>1551588</TD><TD>SA4</TD><TD>56904</TD></TR><TR><TD>1545140</TD><TD>SA4</TD><TD>57487</TD></TR><TR><TD>1545140</TD><TD>SA4</TD><TD>53428</TD></TR><TR><TD>1544804</TD><TD>SA4</TD><TD>51724</TD></TR><TR><TD>1544804</TD><TD>T1</TD><TD>61202</TD></TR><TR><TD>1545086</TD><TD>T1</TD><TD>7805</TD></TR><TR><TD>1537829</TD><TD>T1</TD><TD>50733</TD></TR><TR><TD>1537824</TD><TD>T1</TD><TD>9909</TD></TR><TR><TD>1537933</TD><TD>T2</TD><TD>56978</TD></TR><TR><TD>1537933</TD><TD>T2</TD><TD>12029</TD></TR><TR><TD>1537933</TD><TD>T2</TD><TD>8260</TD></TR><TR><TD>1534214</TD><TD>T2</TD><TD>50712</TD></TR><TR><TD>1534214</TD><TD>T3</TD><TD>50732</TD></TR><TR><TD>1534205</TD><TD>T3</TD><TD>7818</TD></TR><TR><TD>1534205</TD><TD>T3</TD><TD>50914</TD></TR><TR><TD>1530771</TD><TD>T3</TD><TD>8846</TD></TR><TR><TD>1530771</TD><TD>T4</TD><TD>51575</TD></TR><TR><TD>1532969</TD><TD>T4</TD><TD>50736</TD></TR><TR><TD>1532970</TD><TD>T4</TD><TD>59721</TD></TR><TR><TD>1532970</TD><TD>T4</TD><TD>61199</TD></TR></TBODY></TABLE><P>and i would like to expand it based on data filtering to table with nine columns like below. </P><TABLE border="0" cellspacing="0" cellpadding="0"><TBODY><TR><TD>No</TD><TD>SA1</TD><TD>SA2</TD><TD>SA3</TD><TD>SA4</TD><TD>T1</TD><TD>T2</TD><TD>T3</TD><TD>T4</TD></TR><TR><TD>1530771</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD>8846</TD><TD>51575</TD></TR><TR><TD>1532969</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD>50736</TD></TR><TR><TD>1532970</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD>120920</TD></TR><TR><TD>1534205</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD>58732</TD><TD> </TD></TR><TR><TD>1534214</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD>50712</TD><TD>50732</TD><TD> </TD></TR><TR><TD>1537824</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD>9909</TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD>1537829</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD>50733</TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD>1537933</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD>77267</TD><TD> </TD><TD> </TD></TR><TR><TD>1544804</TD><TD> </TD><TD> </TD><TD> </TD><TD>51724</TD><TD>61202</TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD>1545086</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD>7805</TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD>1545140</TD><TD> </TD><TD> </TD><TD> </TD><TD>110915</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD>1551588</TD><TD> </TD><TD> </TD><TD>59723</TD><TD>56904</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD>1558957</TD><TD>52052</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD>1558958</TD><TD> </TD><TD>158591</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD>1559200</TD><TD>61206</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD>1559691</TD><TD> </TD><TD>53429</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD>1559692</TD><TD> </TD><TD> </TD><TD>57488</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD>1559694</TD><TD> </TD><TD> </TD><TD>59725</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD>1560476</TD><TD>6789</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD>1560573</TD><TD> </TD><TD> </TD><TD>8300</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR></TBODY></TABLE><P> </P> Wed, 17 May 2023 14:28:55 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Create-custom-filtered-table/m-p/3240416#M119204 Wirestat 2023-05-17T14:28:55Z Re: Create custom filtered table https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Create-custom-filtered-table/m-p/3240570#M119216 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="379060" data-lia-user-login="Wirestat" class="lia-mention lia-mention-user">Wirestat</a> , Create a matrix visual and use desc in column.</P> <P> </P> <P>If you need a calculated(data) table. Pivot in power query -</P> <P>Pivot Data(Power Query) :<A href="https://www.youtube.com/watch?v=oKByyI09Bno&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=12" target="_blank">https://www.youtube.com/watch?v=oKByyI09Bno&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=12</A></P> Wed, 17 May 2023 15:20:58 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Create-custom-filtered-table/m-p/3240570#M119216 amitchandak 2023-05-17T15:20:58Z