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
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!