topic Re: combine value and separate value to show visual in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/combine-value-and-separate-value-to-show-visual/m-p/1972279#M43349 <P><img /></P> <P>&nbsp;</P> Thu, 22 Jul 2021 07:37:40 GMT wdx223_Daniel 2021-07-22T07:37:40Z combine value and separate value to show visual https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/combine-value-and-separate-value-to-show-visual/m-p/1972200#M43345 <P>i have 5 columns each values are unique vlaues . i have one column DOM Filter .&nbsp; DOM filter have combine value and also seperate value . i have attached sample date for reference&nbsp;</P><P>Code&nbsp; &nbsp; Value 1&nbsp; &nbsp;value 2&nbsp; value 3&nbsp; &nbsp; DOM&nbsp;</P><P>101&nbsp; &nbsp; &nbsp; &nbsp; 5&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 10&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;7&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; A104</P><P>101&nbsp; &nbsp; &nbsp; &nbsp; 5&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 10&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;7&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; B104,S104,A104</P><P>101&nbsp; &nbsp; &nbsp; &nbsp; 5&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 10&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;7&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Z104,R104</P><P>101&nbsp; &nbsp; &nbsp; &nbsp; 5&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 10&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;7&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; G104,A104</P><P>101&nbsp; &nbsp; &nbsp; &nbsp; 5&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 10&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;7&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; O104</P><P>101&nbsp; &nbsp; &nbsp; &nbsp; 5&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 10&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;7&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; R104</P><P>101&nbsp; &nbsp; &nbsp; &nbsp; 5&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 10&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;7&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; S104,Z104&nbsp;&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;I&nbsp; have seperate sheet for DOM filter&nbsp;&nbsp;</P><P>DOM Filter&nbsp;</P><P>A104</P><P>B104</P><P>Z104</P><P>O104</P><P>G104</P><P>R104</P><P>S104</P><P>&nbsp;</P><P>If i select&nbsp; value A104 in&nbsp; filter value should come from combine value and seperate value . like</P><P>&nbsp;</P><P>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;VALUE 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;VALUE 2&nbsp; &nbsp; &nbsp;VALUE 3</P><P>A104&nbsp; &nbsp; &nbsp; &nbsp; 15&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 30&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 21&nbsp;</P><P>any idea ?&nbsp; thanks in advance .</P> Thu, 22 Jul 2021 07:17:30 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/combine-value-and-separate-value-to-show-visual/m-p/1972200#M43345 Anonymous 2021-07-22T07:17:30Z Re: combine value and separate value to show visual https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/combine-value-and-separate-value-to-show-visual/m-p/1972279#M43349 <P><img /></P> <P>&nbsp;</P> Thu, 22 Jul 2021 07:37:40 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/combine-value-and-separate-value-to-show-visual/m-p/1972279#M43349 wdx223_Daniel 2021-07-22T07:37:40Z