Forum Discussion

BenHoward's avatar
BenHoward
Icon for Helper I rankHelper I
5 years ago

create new table using a measure as a filter

I have two tables Table 1 and Table2 which are unrelated, and by using a measure which I build up from a selection of values from Table1, I want to build a 3rd table which is a subset, ie a filter, o...
DAX FILTER
Filter using a measure
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

BenHoward , I doubt you can create a Table using the measure as a filter.

Try using summarizecolumns

BenHoward's avatar
BenHoward
Icon for Helper I rankHelper I
5 years ago

amitchandak - the table is created when using the measure as a filter, it contains data when the measure is written as 

SelectedName = 
VAR R1 = "Rishi"
RETURN R1

but not when the measure is written as 

VAR R1 = SELECTEDVALUE(Table1[Column1])
RETURN R1

I'm trying to understand why this would be.