Forum Discussion

admin_xlsior's avatar
admin_xlsior
Post Prodigy
7 years ago
Solved

FILTER function with indirect relationship

Hi guys,   Let say I have this 3 tables with diagram :   If I want to SUM the amount in my WorkFactTable with Group[Type] for example in that table has value "Type1", what is the DAX statem...
Need Help
parry2k's avatar
parry2k
Super User
7 years ago

admin_xlsior relate function cannot be used with indirect filters. as best practice it will make sense to have group table direct relationship with fact table or you can use crossfilter function.

admin_xlsior's avatar
admin_xlsior
Post Prodigy
7 years ago

Hi,

 

Thanks for replying. Noted on the RELATED function limits. However when I google and look at the samples, it seems CROSSFILTER is just to turn on the relationship, am I right ? how to apply the filter it self ? 

 

Some example from Microsoft Docs:

CROSSFILTER(<columnName1>, <columnName2>, <direction>)

BiDi:= CALCULATE([Distinct Count of ProductKey], CROSSFILTER(FactInternetSales[ProductKey], DimProduct[ProductKey] , Both))

 

Still confuse, where I put the filter condition it self ?

 

Forgive me because I really a newbie in Power BI and DAX.

 

Thanks,

    • admin_xlsior's avatar
      admin_xlsior
      Post Prodigy
      7 years ago

      Hi,

       

      It works. Just what I need. Thank you very much for your help. 

    • Kat_Finra's avatar
      Kat_Finra
      Frequent Visitor
      2 years ago

      THANK YOU!