https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Help-with-DAX-formula-to-pull-various-column-values-into-one/m-p/1447644#M27157 <P>You cannot change the model of a SSAS live connection. No new tables, no new columns. If you want to do that, you need to import the SSAS data through Power Query and shape it there as deisred, then bring it in, but it will be an import and refresh model, not live.</P> Wed, 21 Oct 2020 17:50:36 GMT edhans 2020-10-21T17:50:36Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Help-with-DAX-formula-to-pull-various-column-values-into-one/m-p/1447605#M27154 <P>I have a fairly niche question, and I was hoping someone could help me with this.</P><P>&nbsp;</P><P>First off I am using a live connect to Azure Analysis Services so Query Editor in PowerBI isnt an option, so I beleive I need to find a way to do this in DAX.</P><P>&nbsp;</P><P>Right now I have 8 different tables from different source systems each with&nbsp;their own KPI measure. In total there are ~130 KPI measures.</P><P>&nbsp;</P><P>I want to create one table where ALL of the KPI values are listed in one column</P><P>&nbsp;</P><P>So for example:</P><P>&nbsp;</P><P>Table 1 : (I have&nbsp;4&nbsp; KPI values for 2 different KPI @ 2 different locations)</P><P>&nbsp;</P><P>Location:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; KPI Name&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; KPI Value</P><P>Location 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; KPI 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Value 1</P><P>Location 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; KPI&nbsp;1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Value 2</P><P>Location&nbsp;1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; KPI&nbsp;2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Value 3</P><P>Location&nbsp;2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; KPI&nbsp;2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Value 4</P><P>&nbsp;</P><P>Table 2: (I have&nbsp;4 different&nbsp; KPI values for 2 different KPI @ 2 different locations)</P><P>&nbsp;</P><P>Location:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; KPI Name&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; KPI Value</P><P>Location&nbsp;1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; KPI&nbsp;3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Value 5</P><P>Location&nbsp;&nbsp;2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;KPI&nbsp;3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Value 6</P><P>Location&nbsp;1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; KPI&nbsp;4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Value 7</P><P>Location&nbsp;2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; KPI&nbsp;4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Value 8</P><P>&nbsp;</P><P>Combined table: (All KPI values&nbsp; for all different KPI are in one column)</P><P>&nbsp;</P><P>Location:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; KPI Name&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; KPI Value</P><P>Location&nbsp;1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; KPI&nbsp;1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Value 1</P><P>Location&nbsp;&nbsp;2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;KPI&nbsp;1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Value 2</P><P>Location&nbsp;1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; KPI&nbsp;2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Value 3</P><P>Location&nbsp;&nbsp;2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;KPI&nbsp;2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Value 4</P><P>Location&nbsp;1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; KPI&nbsp;3 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Value 5</P><P>Location&nbsp;&nbsp;2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;KPI&nbsp;3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Value 6</P><P>Location&nbsp;1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; KPI&nbsp;4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Value 7</P><P>Location&nbsp;&nbsp;2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;KPI&nbsp;4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Value 8</P><P>&nbsp;</P><P>I know this might be a bit of a strange challenge. Any feedback would be greatly appreciated. I am also open to any suggestions that may arrive at a similar result but through a different strategy.</P><P>&nbsp;</P><P>Thanks!</P> Wed, 21 Oct 2020 17:03:18 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Help-with-DAX-formula-to-pull-various-column-values-into-one/m-p/1447605#M27154 ConnorA 2020-10-21T17:03:18Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Help-with-DAX-formula-to-pull-various-column-values-into-one/m-p/1447644#M27157 <P>You cannot change the model of a SSAS live connection. No new tables, no new columns. If you want to do that, you need to import the SSAS data through Power Query and shape it there as deisred, then bring it in, but it will be an import and refresh model, not live.</P> Wed, 21 Oct 2020 17:50:36 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Help-with-DAX-formula-to-pull-various-column-values-into-one/m-p/1447644#M27157 edhans 2020-10-21T17:50:36Z