topic Selecting between a dynamic list of values for matrix row in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Selecting-between-a-dynamic-list-of-values-for-matrix-row/m-p/4418385#M175441 <P>is there any way to have a dynamic measure that will let me pick and choose individual values from two different columns and toggle between name or job title depending on which i would like to see? i know i can do this as a whole (either all fully showing names or all showing job titles) with a parameter but I am looking to do this on an individual level and have the rows be dynamic. ie: I want to see names under Accounting, but Job titles for Analytics. Snip of what the background data looks like below as well.</P><P><img /></P><P>&nbsp;</P><P><BR /><BR /><BR /><BR /><BR /><BR /></P><TABLE border="1"><TBODY><TR><TD>Name</TD><TD>Hours</TD><TD>Team</TD><TD>Month</TD><TD>Job Title</TD><TD>Department</TD></TR><TR><TD>Diane Duke</TD><TD>14</TD><TD>Trident</TD><TD>1/1/2026</TD><TD>Commercial Analyst</TD><TD>Analytics</TD></TR><TR><TD>Diane Duke</TD><TD>9</TD><TD>Trident</TD><TD>10/1/2025</TD><TD>Commercial Analyst</TD><TD>Analytics</TD></TR><TR><TD>Diane Duke</TD><TD>5</TD><TD>Trident</TD><TD>11/1/2025</TD><TD>Commercial Analyst</TD><TD>Analytics</TD></TR><TR><TD>Diane Duke</TD><TD>11</TD><TD>Trident</TD><TD>12/1/2025</TD><TD>Commercial Analyst</TD><TD>Analytics</TD></TR><TR><TD>Diane Duke</TD><TD>32</TD><TD>Trident</TD><TD>2/1/2025</TD><TD>Commercial Analyst</TD><TD>Analytics</TD></TR><TR><TD>Diane Duke</TD><TD>25</TD><TD>Trident</TD><TD>2/1/2026</TD><TD>Commercial Analyst</TD><TD>Analytics</TD></TR><TR><TD>Diane Duke</TD><TD>7</TD><TD>Trident</TD><TD>3/1/2025</TD><TD>Commercial Analyst</TD><TD>Analytics</TD></TR><TR><TD>Diane Duke</TD><TD>31</TD><TD>Trident</TD><TD>3/1/2026</TD><TD>Commercial Analyst</TD><TD>Analytics</TD></TR><TR><TD>Diane Duke</TD><TD>17</TD><TD>Trident</TD><TD>4/1/2025</TD><TD>Commercial Analyst</TD><TD>Analytics</TD></TR><TR><TD>Diane Duke</TD><TD>35</TD><TD>Trident</TD><TD>4/1/2026</TD><TD>Commercial Analyst</TD><TD>Analytics</TD></TR><TR><TD>Diane Duke</TD><TD>23</TD><TD>Trident</TD><TD>5/1/2025</TD><TD>Commercial Analyst</TD><TD>Analytics</TD></TR><TR><TD>Diane Duke</TD><TD>31</TD><TD>Trident</TD><TD>5/1/2026</TD><TD>Commercial Analyst</TD><TD>Analytics</TD></TR><TR><TD>Diane Duke</TD><TD>33</TD><TD>Trident</TD><TD>6/1/2025</TD><TD>Commercial Analyst</TD><TD>Analytics</TD></TR><TR><TD>Diane Duke</TD><TD>32</TD><TD>Trident</TD><TD>7/1/2025</TD><TD>Commercial Analyst</TD><TD>Analytics</TD></TR><TR><TD>Diane Duke</TD><TD>36</TD><TD>Trident</TD><TD>8/1/2025</TD><TD>Commercial Analyst</TD><TD>Analytics</TD></TR><TR><TD>Diane Duke</TD><TD>3</TD><TD>Trident</TD><TD>9/1/2025</TD><TD>Commercial Analyst</TD><TD>Analytics</TD></TR><TR><TD>Hayden Guerra</TD><TD>30</TD><TD>Trident</TD><TD>1/1/2026</TD><TD>Computer Support Specialist</TD><TD>IT</TD></TR><TR><TD>Hayden Guerra</TD><TD>25</TD><TD>Trident</TD><TD>10/1/2025</TD><TD>Computer Support Specialist</TD><TD>IT</TD></TR><TR><TD>Hayden Guerra</TD><TD>12</TD><TD>Trident</TD><TD>11/1/2025</TD><TD>Computer Support Specialist</TD><TD>IT</TD></TR><TR><TD>Hayden Guerra</TD><TD>40</TD><TD>Trident</TD><TD>12/1/2025</TD><TD>Computer Support Specialist</TD><TD>IT</TD></TR><TR><TD>Hayden Guerra</TD><TD>39</TD><TD>Trident</TD><TD>2/1/2025</TD><TD>Computer Support Specialist</TD><TD>IT</TD></TR><TR><TD>Hayden Guerra</TD><TD>0</TD><TD>Trident</TD><TD>2/1/2026</TD><TD>Computer Support Specialist</TD><TD>IT</TD></TR><TR><TD>Hayden Guerra</TD><TD>19</TD><TD>Trident</TD><TD>3/1/2025</TD><TD>Computer Support Specialist</TD><TD>IT</TD></TR><TR><TD>Hayden Guerra</TD><TD>35</TD><TD>Trident</TD><TD>3/1/2026</TD><TD>Computer Support Specialist</TD><TD>IT</TD></TR><TR><TD>Hayden Guerra</TD><TD>6</TD><TD>Trident</TD><TD>4/1/2025</TD><TD>Computer Support Specialist</TD><TD>IT</TD></TR><TR><TD>Hayden Guerra</TD><TD>2</TD><TD>Trident</TD><TD>4/1/2026</TD><TD>Computer Support Specialist</TD><TD>IT</TD></TR><TR><TD>Hayden Guerra</TD><TD>18</TD><TD>Trident</TD><TD>5/1/2025</TD><TD>Computer Support Specialist</TD><TD>IT</TD></TR><TR><TD>Hayden Guerra</TD><TD>35</TD><TD>Trident</TD><TD>5/1/2026</TD><TD>Computer Support Specialist</TD><TD>IT</TD></TR><TR><TD>Hayden Guerra</TD><TD>26</TD><TD>Trident</TD><TD>6/1/2025</TD><TD>Computer Support Specialist</TD><TD>IT</TD></TR><TR><TD>Hayden Guerra</TD><TD>36</TD><TD>Trident</TD><TD>7/1/2025</TD><TD>Computer Support Specialist</TD><TD>IT</TD></TR><TR><TD>Hayden Guerra</TD><TD>2</TD><TD>Trident</TD><TD>8/1/2025</TD><TD>Computer Support Specialist</TD><TD>IT</TD></TR><TR><TD>Hayden Guerra</TD><TD>19</TD><TD>Trident</TD><TD>9/1/2025</TD><TD>Computer Support Specialist</TD><TD>IT</TD></TR><TR><TD>Renato Charles</TD><TD>28</TD><TD>Trident</TD><TD>1/1/2026</TD><TD>Controller</TD><TD>Accounting</TD></TR><TR><TD>Renato Charles</TD><TD>17</TD><TD>Trident</TD><TD>10/1/2025</TD><TD>Controller</TD><TD>Accounting</TD></TR><TR><TD>Renato Charles</TD><TD>5</TD><TD>Trident</TD><TD>11/1/2025</TD><TD>Controller</TD><TD>Accounting</TD></TR><TR><TD>Renato Charles</TD><TD>4</TD><TD>Trident</TD><TD>12/1/2025</TD><TD>Controller</TD><TD>Accounting</TD></TR><TR><TD>Renato Charles</TD><TD>28</TD><TD>Trident</TD><TD>2/1/2025</TD><TD>Controller</TD><TD>Accounting</TD></TR><TR><TD>Renato Charles</TD><TD>19</TD><TD>Trident</TD><TD>2/1/2026</TD><TD>Controller</TD><TD>Accounting</TD></TR><TR><TD>Renato Charles</TD><TD>2</TD><TD>Trident</TD><TD>3/1/2025</TD><TD>Controller</TD><TD>Accounting</TD></TR><TR><TD>Renato Charles</TD><TD>23</TD><TD>Trident</TD><TD>3/1/2026</TD><TD>Controller</TD><TD>Accounting</TD></TR><TR><TD>Renato Charles</TD><TD>32</TD><TD>Trident</TD><TD>4/1/2025</TD><TD>Controller</TD><TD>Accounting</TD></TR><TR><TD>Renato Charles</TD><TD>13</TD><TD>Trident</TD><TD>4/1/2026</TD><TD>Controller</TD><TD>Accounting</TD></TR><TR><TD>Renato Charles</TD><TD>24</TD><TD>Trident</TD><TD>5/1/2025</TD><TD>Controller</TD><TD>Accounting</TD></TR><TR><TD>Renato Charles</TD><TD>34</TD><TD>Trident</TD><TD>5/1/2026</TD><TD>Controller</TD><TD>Accounting</TD></TR><TR><TD>Renato Charles</TD><TD>10</TD><TD>Trident</TD><TD>6/1/2025</TD><TD>Controller</TD><TD>Accounting</TD></TR><TR><TD>Renato Charles</TD><TD>11</TD><TD>Trident</TD><TD>7/1/2025</TD><TD>Controller</TD><TD>Accounting</TD></TR><TR><TD>Renato Charles</TD><TD>3</TD><TD>Trident</TD><TD>8/1/2025</TD><TD>Controller</TD><TD>Accounting</TD></TR><TR><TD>Renato Charles</TD><TD>34</TD><TD>Trident</TD><TD>9/1/2025</TD><TD>Controller</TD><TD>Accounting</TD></TR><TR><TD>Brian Walker</TD><TD>36</TD><TD>Trident</TD><TD>1/1/2026</TD><TD>Executive Vice President</TD><TD>Management</TD></TR><TR><TD>Brian Walker</TD><TD>7</TD><TD>Trident</TD><TD>10/1/2025</TD><TD>Executive Vice President</TD><TD>Management</TD></TR><TR><TD>Brian Walker</TD><TD>39</TD><TD>Trident</TD><TD>11/1/2025</TD><TD>Executive Vice President</TD><TD>Management</TD></TR><TR><TD>Brian Walker</TD><TD>19</TD><TD>Trident</TD><TD>12/1/2025</TD><TD>Executive Vice President</TD><TD>Management</TD></TR><TR><TD>Brian Walker</TD><TD>28</TD><TD>Trident</TD><TD>2/1/2025</TD><TD>Executive Vice President</TD><TD>Management</TD></TR><TR><TD>Brian Walker</TD><TD>14</TD><TD>Trident</TD><TD>2/1/2026</TD><TD>Executive Vice President</TD><TD>Management</TD></TR><TR><TD>Brian Walker</TD><TD>0</TD><TD>Trident</TD><TD>3/1/2025</TD><TD>Executive Vice President</TD><TD>Management</TD></TR><TR><TD>Brian Walker</TD><TD>35</TD><TD>Trident</TD><TD>3/1/2026</TD><TD>Executive Vice President</TD><TD>Management</TD></TR><TR><TD>Brian Walker</TD><TD>6</TD><TD>Trident</TD><TD>4/1/2025</TD><TD>Executive Vice President</TD><TD>Management</TD></TR><TR><TD>Brian Walker</TD><TD>19</TD><TD>Trident</TD><TD>4/1/2026</TD><TD>Executive Vice President</TD><TD>Management</TD></TR><TR><TD>Brian Walker</TD><TD>11</TD><TD>Trident</TD><TD>5/1/2025</TD><TD>Executive Vice President</TD><TD>Management</TD></TR><TR><TD>Brian Walker</TD><TD>39</TD><TD>Trident</TD><TD>5/1/2026</TD><TD>Executive Vice President</TD><TD>Management</TD></TR><TR><TD>Brian Walker</TD><TD>39</TD><TD>Trident</TD><TD>6/1/2025</TD><TD>Executive Vice President</TD><TD>Management</TD></TR><TR><TD>Brian Walker</TD><TD>3</TD><TD>Trident</TD><TD>7/1/2025</TD><TD>Executive Vice President</TD><TD>Management</TD></TR><TR><TD>Brian Walker</TD><TD>1</TD><TD>Trident</TD><TD>8/1/2025</TD><TD>Executive Vice President</TD><TD>Management</TD></TR><TR><TD>Brian Walker</TD><TD>35</TD><TD>Trident</TD><TD>9/1/2025</TD><TD>Executive Vice President</TD><TD>Management</TD></TR></TBODY></TABLE> Wed, 19 Feb 2025 22:13:09 GMT anna-lee 2025-02-19T22:13:09Z Selecting between a dynamic list of values for matrix row https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Selecting-between-a-dynamic-list-of-values-for-matrix-row/m-p/4418385#M175441 <P>is there any way to have a dynamic measure that will let me pick and choose individual values from two different columns and toggle between name or job title depending on which i would like to see? i know i can do this as a whole (either all fully showing names or all showing job titles) with a parameter but I am looking to do this on an individual level and have the rows be dynamic. ie: I want to see names under Accounting, but Job titles for Analytics. Snip of what the background data looks like below as well.</P><P><img /></P><P>&nbsp;</P><P><BR /><BR /><BR /><BR /><BR /><BR /></P><TABLE border="1"><TBODY><TR><TD>Name</TD><TD>Hours</TD><TD>Team</TD><TD>Month</TD><TD>Job Title</TD><TD>Department</TD></TR><TR><TD>Diane Duke</TD><TD>14</TD><TD>Trident</TD><TD>1/1/2026</TD><TD>Commercial Analyst</TD><TD>Analytics</TD></TR><TR><TD>Diane Duke</TD><TD>9</TD><TD>Trident</TD><TD>10/1/2025</TD><TD>Commercial Analyst</TD><TD>Analytics</TD></TR><TR><TD>Diane Duke</TD><TD>5</TD><TD>Trident</TD><TD>11/1/2025</TD><TD>Commercial Analyst</TD><TD>Analytics</TD></TR><TR><TD>Diane Duke</TD><TD>11</TD><TD>Trident</TD><TD>12/1/2025</TD><TD>Commercial Analyst</TD><TD>Analytics</TD></TR><TR><TD>Diane Duke</TD><TD>32</TD><TD>Trident</TD><TD>2/1/2025</TD><TD>Commercial Analyst</TD><TD>Analytics</TD></TR><TR><TD>Diane Duke</TD><TD>25</TD><TD>Trident</TD><TD>2/1/2026</TD><TD>Commercial Analyst</TD><TD>Analytics</TD></TR><TR><TD>Diane Duke</TD><TD>7</TD><TD>Trident</TD><TD>3/1/2025</TD><TD>Commercial Analyst</TD><TD>Analytics</TD></TR><TR><TD>Diane Duke</TD><TD>31</TD><TD>Trident</TD><TD>3/1/2026</TD><TD>Commercial Analyst</TD><TD>Analytics</TD></TR><TR><TD>Diane Duke</TD><TD>17</TD><TD>Trident</TD><TD>4/1/2025</TD><TD>Commercial Analyst</TD><TD>Analytics</TD></TR><TR><TD>Diane Duke</TD><TD>35</TD><TD>Trident</TD><TD>4/1/2026</TD><TD>Commercial Analyst</TD><TD>Analytics</TD></TR><TR><TD>Diane Duke</TD><TD>23</TD><TD>Trident</TD><TD>5/1/2025</TD><TD>Commercial Analyst</TD><TD>Analytics</TD></TR><TR><TD>Diane Duke</TD><TD>31</TD><TD>Trident</TD><TD>5/1/2026</TD><TD>Commercial Analyst</TD><TD>Analytics</TD></TR><TR><TD>Diane Duke</TD><TD>33</TD><TD>Trident</TD><TD>6/1/2025</TD><TD>Commercial Analyst</TD><TD>Analytics</TD></TR><TR><TD>Diane Duke</TD><TD>32</TD><TD>Trident</TD><TD>7/1/2025</TD><TD>Commercial Analyst</TD><TD>Analytics</TD></TR><TR><TD>Diane Duke</TD><TD>36</TD><TD>Trident</TD><TD>8/1/2025</TD><TD>Commercial Analyst</TD><TD>Analytics</TD></TR><TR><TD>Diane Duke</TD><TD>3</TD><TD>Trident</TD><TD>9/1/2025</TD><TD>Commercial Analyst</TD><TD>Analytics</TD></TR><TR><TD>Hayden Guerra</TD><TD>30</TD><TD>Trident</TD><TD>1/1/2026</TD><TD>Computer Support Specialist</TD><TD>IT</TD></TR><TR><TD>Hayden Guerra</TD><TD>25</TD><TD>Trident</TD><TD>10/1/2025</TD><TD>Computer Support Specialist</TD><TD>IT</TD></TR><TR><TD>Hayden Guerra</TD><TD>12</TD><TD>Trident</TD><TD>11/1/2025</TD><TD>Computer Support Specialist</TD><TD>IT</TD></TR><TR><TD>Hayden Guerra</TD><TD>40</TD><TD>Trident</TD><TD>12/1/2025</TD><TD>Computer Support Specialist</TD><TD>IT</TD></TR><TR><TD>Hayden Guerra</TD><TD>39</TD><TD>Trident</TD><TD>2/1/2025</TD><TD>Computer Support Specialist</TD><TD>IT</TD></TR><TR><TD>Hayden Guerra</TD><TD>0</TD><TD>Trident</TD><TD>2/1/2026</TD><TD>Computer Support Specialist</TD><TD>IT</TD></TR><TR><TD>Hayden Guerra</TD><TD>19</TD><TD>Trident</TD><TD>3/1/2025</TD><TD>Computer Support Specialist</TD><TD>IT</TD></TR><TR><TD>Hayden Guerra</TD><TD>35</TD><TD>Trident</TD><TD>3/1/2026</TD><TD>Computer Support Specialist</TD><TD>IT</TD></TR><TR><TD>Hayden Guerra</TD><TD>6</TD><TD>Trident</TD><TD>4/1/2025</TD><TD>Computer Support Specialist</TD><TD>IT</TD></TR><TR><TD>Hayden Guerra</TD><TD>2</TD><TD>Trident</TD><TD>4/1/2026</TD><TD>Computer Support Specialist</TD><TD>IT</TD></TR><TR><TD>Hayden Guerra</TD><TD>18</TD><TD>Trident</TD><TD>5/1/2025</TD><TD>Computer Support Specialist</TD><TD>IT</TD></TR><TR><TD>Hayden Guerra</TD><TD>35</TD><TD>Trident</TD><TD>5/1/2026</TD><TD>Computer Support Specialist</TD><TD>IT</TD></TR><TR><TD>Hayden Guerra</TD><TD>26</TD><TD>Trident</TD><TD>6/1/2025</TD><TD>Computer Support Specialist</TD><TD>IT</TD></TR><TR><TD>Hayden Guerra</TD><TD>36</TD><TD>Trident</TD><TD>7/1/2025</TD><TD>Computer Support Specialist</TD><TD>IT</TD></TR><TR><TD>Hayden Guerra</TD><TD>2</TD><TD>Trident</TD><TD>8/1/2025</TD><TD>Computer Support Specialist</TD><TD>IT</TD></TR><TR><TD>Hayden Guerra</TD><TD>19</TD><TD>Trident</TD><TD>9/1/2025</TD><TD>Computer Support Specialist</TD><TD>IT</TD></TR><TR><TD>Renato Charles</TD><TD>28</TD><TD>Trident</TD><TD>1/1/2026</TD><TD>Controller</TD><TD>Accounting</TD></TR><TR><TD>Renato Charles</TD><TD>17</TD><TD>Trident</TD><TD>10/1/2025</TD><TD>Controller</TD><TD>Accounting</TD></TR><TR><TD>Renato Charles</TD><TD>5</TD><TD>Trident</TD><TD>11/1/2025</TD><TD>Controller</TD><TD>Accounting</TD></TR><TR><TD>Renato Charles</TD><TD>4</TD><TD>Trident</TD><TD>12/1/2025</TD><TD>Controller</TD><TD>Accounting</TD></TR><TR><TD>Renato Charles</TD><TD>28</TD><TD>Trident</TD><TD>2/1/2025</TD><TD>Controller</TD><TD>Accounting</TD></TR><TR><TD>Renato Charles</TD><TD>19</TD><TD>Trident</TD><TD>2/1/2026</TD><TD>Controller</TD><TD>Accounting</TD></TR><TR><TD>Renato Charles</TD><TD>2</TD><TD>Trident</TD><TD>3/1/2025</TD><TD>Controller</TD><TD>Accounting</TD></TR><TR><TD>Renato Charles</TD><TD>23</TD><TD>Trident</TD><TD>3/1/2026</TD><TD>Controller</TD><TD>Accounting</TD></TR><TR><TD>Renato Charles</TD><TD>32</TD><TD>Trident</TD><TD>4/1/2025</TD><TD>Controller</TD><TD>Accounting</TD></TR><TR><TD>Renato Charles</TD><TD>13</TD><TD>Trident</TD><TD>4/1/2026</TD><TD>Controller</TD><TD>Accounting</TD></TR><TR><TD>Renato Charles</TD><TD>24</TD><TD>Trident</TD><TD>5/1/2025</TD><TD>Controller</TD><TD>Accounting</TD></TR><TR><TD>Renato Charles</TD><TD>34</TD><TD>Trident</TD><TD>5/1/2026</TD><TD>Controller</TD><TD>Accounting</TD></TR><TR><TD>Renato Charles</TD><TD>10</TD><TD>Trident</TD><TD>6/1/2025</TD><TD>Controller</TD><TD>Accounting</TD></TR><TR><TD>Renato Charles</TD><TD>11</TD><TD>Trident</TD><TD>7/1/2025</TD><TD>Controller</TD><TD>Accounting</TD></TR><TR><TD>Renato Charles</TD><TD>3</TD><TD>Trident</TD><TD>8/1/2025</TD><TD>Controller</TD><TD>Accounting</TD></TR><TR><TD>Renato Charles</TD><TD>34</TD><TD>Trident</TD><TD>9/1/2025</TD><TD>Controller</TD><TD>Accounting</TD></TR><TR><TD>Brian Walker</TD><TD>36</TD><TD>Trident</TD><TD>1/1/2026</TD><TD>Executive Vice President</TD><TD>Management</TD></TR><TR><TD>Brian Walker</TD><TD>7</TD><TD>Trident</TD><TD>10/1/2025</TD><TD>Executive Vice President</TD><TD>Management</TD></TR><TR><TD>Brian Walker</TD><TD>39</TD><TD>Trident</TD><TD>11/1/2025</TD><TD>Executive Vice President</TD><TD>Management</TD></TR><TR><TD>Brian Walker</TD><TD>19</TD><TD>Trident</TD><TD>12/1/2025</TD><TD>Executive Vice President</TD><TD>Management</TD></TR><TR><TD>Brian Walker</TD><TD>28</TD><TD>Trident</TD><TD>2/1/2025</TD><TD>Executive Vice President</TD><TD>Management</TD></TR><TR><TD>Brian Walker</TD><TD>14</TD><TD>Trident</TD><TD>2/1/2026</TD><TD>Executive Vice President</TD><TD>Management</TD></TR><TR><TD>Brian Walker</TD><TD>0</TD><TD>Trident</TD><TD>3/1/2025</TD><TD>Executive Vice President</TD><TD>Management</TD></TR><TR><TD>Brian Walker</TD><TD>35</TD><TD>Trident</TD><TD>3/1/2026</TD><TD>Executive Vice President</TD><TD>Management</TD></TR><TR><TD>Brian Walker</TD><TD>6</TD><TD>Trident</TD><TD>4/1/2025</TD><TD>Executive Vice President</TD><TD>Management</TD></TR><TR><TD>Brian Walker</TD><TD>19</TD><TD>Trident</TD><TD>4/1/2026</TD><TD>Executive Vice President</TD><TD>Management</TD></TR><TR><TD>Brian Walker</TD><TD>11</TD><TD>Trident</TD><TD>5/1/2025</TD><TD>Executive Vice President</TD><TD>Management</TD></TR><TR><TD>Brian Walker</TD><TD>39</TD><TD>Trident</TD><TD>5/1/2026</TD><TD>Executive Vice President</TD><TD>Management</TD></TR><TR><TD>Brian Walker</TD><TD>39</TD><TD>Trident</TD><TD>6/1/2025</TD><TD>Executive Vice President</TD><TD>Management</TD></TR><TR><TD>Brian Walker</TD><TD>3</TD><TD>Trident</TD><TD>7/1/2025</TD><TD>Executive Vice President</TD><TD>Management</TD></TR><TR><TD>Brian Walker</TD><TD>1</TD><TD>Trident</TD><TD>8/1/2025</TD><TD>Executive Vice President</TD><TD>Management</TD></TR><TR><TD>Brian Walker</TD><TD>35</TD><TD>Trident</TD><TD>9/1/2025</TD><TD>Executive Vice President</TD><TD>Management</TD></TR></TBODY></TABLE> Wed, 19 Feb 2025 22:13:09 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Selecting-between-a-dynamic-list-of-values-for-matrix-row/m-p/4418385#M175441 anna-lee 2025-02-19T22:13:09Z Re: Selecting between a dynamic list of values for matrix row https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Selecting-between-a-dynamic-list-of-values-for-matrix-row/m-p/4418512#M175444 <LI-CODE lang="markup">ie: I want to see names under Accounting, but Job titles for Analytics</LI-CODE> <P>That is not possible, not even remotely.&nbsp; Use separate visuals.</P> Thu, 20 Feb 2025 00:43:16 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Selecting-between-a-dynamic-list-of-values-for-matrix-row/m-p/4418512#M175444 lbendlin 2025-02-20T00:43:16Z Re: Selecting between a dynamic list of values for matrix row https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Selecting-between-a-dynamic-list-of-values-for-matrix-row/m-p/4418519#M175445 <P>To create a dynamic measure that lets you toggle between "Name" and "Job Title":</P><P>Create a parameter table with options "Name" and "Job Title."<BR />Create a DAX measure like this:<BR />Dynamic Display =<BR />SWITCH(<BR />TRUE(),<BR />SELECTEDVALUE('ParameterTable'[Display Option]) = "Name", SELECTEDVALUE('DataTable'[Name]),<BR />SELECTEDVALUE('ParameterTable'[Display Option]) = "Job Title", SELECTEDVALUE('DataTable'[Job Title])<BR />)<BR /><BR />Add a slicer with the parameter table so you can toggle between "Name" and "Job Title."<BR /><A href="https://help.zebrabi.com/kb/power-bi/dynamic-measure-switch/" target="_blank">https://help.zebrabi.com/kb/power-bi/dynamic-measure-switch/</A></P><P><BR />If this response was helpful, please<STRONG> accept it as a solution</STRONG> and give <STRONG>kudos</STRONG> to help other community members</P> Thu, 20 Feb 2025 00:49:30 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Selecting-between-a-dynamic-list-of-values-for-matrix-row/m-p/4418519#M175445 ArwaAldoud 2025-02-20T00:49:30Z