https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Virtual-table/m-p/3668753#M142258 <P><img /></P><P>How may I Return Only STR_NUM not the KPI(OTP). I'm trying to return only one culomn with store numbers so I can use it as a refrence list in a logical DAX expression like if this store exists in table is "Bottom 50 OTP" and so on.&nbsp;</P> Tue, 30 Jan 2024 18:08:32 GMT Anonymous 2024-01-30T18:08:32Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Virtual-table/m-p/3668753#M142258 <P><img /></P><P>How may I Return Only STR_NUM not the KPI(OTP). I'm trying to return only one culomn with store numbers so I can use it as a refrence list in a logical DAX expression like if this store exists in table is "Bottom 50 OTP" and so on.&nbsp;</P> Tue, 30 Jan 2024 18:08:32 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Virtual-table/m-p/3668753#M142258 Anonymous 2024-01-30T18:08:32Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Virtual-table/m-p/3668891#M142263 <P>Anonymous</LI-USER>&nbsp;Use SELECTCOLUMNS</P> Tue, 30 Jan 2024 19:35:18 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Virtual-table/m-p/3668891#M142263 Greg_Deckler 2024-01-30T19:35:18Z