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
Ian_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?
