Forum Discussion
Ian_Stuart_Rupe
Advocate III
Advocate IIICreating a table in DAX using a fliter
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...
Ian_Stuart_RupeAdvocate III
Advocate IIIand [Selected Student Key] is a measure
parry2k
Super User
Super UserIan_Stuart_Rupe what is the expression of [Selected Student Key] measure
- Ian_Stuart_Rupe
parry2k here you go:
Selected Student Key = SELECTEDVALUE(Dim_Student[Dim_Student_Key])- parry2k
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?
- parry2k
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.
So question here is why you need a table?