Creating a table in DAX using a fliter

Question

I am sure there is a way to do this but I am pulling my hair out!

As a DAX table expression this works (returns expected number of rows):

Filtered Fact = FILTER(Fact_Event,Fact_Event[Dim_Student_Key] = 12071)

Whereas this doesn't (does not filter rows at all):

Filtered Fact = FILTER(Fact_Event,Fact_Event[Dim_Student_Key] = [Selected Student Key])

[Selected Student Key] evaluates to 12071 and is an integer.

What am I doing wrong?

ian_stuart_rupe · Answer

and&nbsp;[Selected Student Key] is a measure

parry2k · Answer

Ian_Stuart_Rupe what is the expression of [Selected Student Key] measure

ian_stuart_rupe · Answer

parry2k&nbsp; here you go:&nbsp;Selected Student Key = SELECTEDVALUE(Dim_Student[Dim_Student_Key])

parry2k · Answer

Ian_Stuart_Rupe so your fact doesn't have relationship with Dim_Student?? if yes then why you need to filter, once you filter dim student it will filter fact table?
&nbsp;
&nbsp;

parry2k · Answer

Ian_Stuart_Rupe sorry read your post again, seems like you are trying to create a table with filtered student, unfortunately you cannot pass slicer value to when creating table using DAX and that is the reason your first expression works and 2nd one doesn't.
&nbsp;
So question here is why you need a table?

Forum Discussion

Creating a table in DAX using a fliter

7 Replies

Related content

Create new table

Lakehouse Table Generate Create Table

Fliter dataset

Create rows from 2 tables

Creating Date Tables