https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/All-values-of-all-levels-of-a-hierarchy-available-in-Report/m-p/3756644#M146564 <P>Hi&nbsp;Anonymous</LI-USER>&nbsp;,</P> <P>Based on your problems, here are my answers.</P> <P>I create a table as you mentioned.</P> <P><img /></P> <P>Open <STRONG>Power Query</STRONG>, select <STRONG>Unpivoted Columns</STRONG>, save and exit.</P> <P><img /></P> <P>Then I create a new table and write the DAX code.</P> <LI-CODE lang="markup">Table 2 = VALUES ( 'Table'[Value] )</LI-CODE> <P><img /></P> <P>Finally you will see what you want.</P> <P><img /></P> <P>&nbsp;</P> <P>&nbsp;</P> <P style="margin-bottom: 6.0pt;"><SPAN>Best Regards</SPAN></P> <P style="margin-bottom: 6.0pt;"><SPAN>Yilong Zhou</SPAN></P> <P style="margin-bottom: 6.0pt;"><SPAN>If this post&nbsp;<STRONG><I>helps</I></STRONG>, then please consider&nbsp;<STRONG><I>Accept it as the solution</I></STRONG>&nbsp;to help the other members find it more quickly.</SPAN></P> Tue, 12 Mar 2024 02:18:33 GMT Anonymous 2024-03-12T02:18:33Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/All-values-of-all-levels-of-a-hierarchy-available-in-Report/m-p/3755369#M146509 <P>Hi,&nbsp;</P><P>&nbsp;</P><P>I have a hierarchy like the one below:</P><TABLE border="0" cellspacing="0" cellpadding="0"><TBODY><TR><TD>Level 1</TD><TD>Level 2</TD><TD>Level 3</TD></TR><TR><TD>A</TD><TD>B</TD><TD>D</TD></TR><TR><TD>A</TD><TD>B</TD><TD>E</TD></TR><TR><TD>A</TD><TD>B</TD><TD>F</TD></TR><TR><TD>A</TD><TD>C</TD><TD>G</TD></TR><TR><TD>A</TD><TD>C</TD><TD>H</TD></TR><TR><TD>A</TD><TD>C</TD><TD>I</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>I please need all the available values of all levels available for selection as a single Report Parameter in Paginated. As follows:</P><P>&nbsp;</P><P>Parameter</P><P>A</P><P>B</P><P>C</P><P>D</P><P>E</P><P>F</P><P>G</P><P>H</P><P>I</P><P>Please help me. I think that it can be done with DAX <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P><P>&nbsp;</P> Mon, 11 Mar 2024 13:17:21 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/All-values-of-all-levels-of-a-hierarchy-available-in-Report/m-p/3755369#M146509 Anonymous 2024-03-11T13:17:21Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/All-values-of-all-levels-of-a-hierarchy-available-in-Report/m-p/3756644#M146564 <P>Hi&nbsp;Anonymous</LI-USER>&nbsp;,</P> <P>Based on your problems, here are my answers.</P> <P>I create a table as you mentioned.</P> <P><img /></P> <P>Open <STRONG>Power Query</STRONG>, select <STRONG>Unpivoted Columns</STRONG>, save and exit.</P> <P><img /></P> <P>Then I create a new table and write the DAX code.</P> <LI-CODE lang="markup">Table 2 = VALUES ( 'Table'[Value] )</LI-CODE> <P><img /></P> <P>Finally you will see what you want.</P> <P><img /></P> <P>&nbsp;</P> <P>&nbsp;</P> <P style="margin-bottom: 6.0pt;"><SPAN>Best Regards</SPAN></P> <P style="margin-bottom: 6.0pt;"><SPAN>Yilong Zhou</SPAN></P> <P style="margin-bottom: 6.0pt;"><SPAN>If this post&nbsp;<STRONG><I>helps</I></STRONG>, then please consider&nbsp;<STRONG><I>Accept it as the solution</I></STRONG>&nbsp;to help the other members find it more quickly.</SPAN></P> Tue, 12 Mar 2024 02:18:33 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/All-values-of-all-levels-of-a-hierarchy-available-in-Report/m-p/3756644#M146564 Anonymous 2024-03-12T02:18:33Z