Forum Discussion

dnl_8's avatar
dnl_8
New Member
3 years ago

Overwrite relationship filter to get other Sales

Hi, I am wondering how can I do the following: I have a table: Card CardID CompanyID Card1 Company1 Card2 Company2   Sales Card ID Customer ID Sales Card1 Customer1 ...
Need Help
Tips and Tricks
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
3 years ago

dnl_8 You need to use ALL to bring all of the rows into context and then filter for NoCard. Like this:

No Card = 
    VAR __Customers = DISTINCT('Table2'[Customer ID])
    VAR __Table = FILTER(ALL('Table2'), Table2[Customer ID] IN __Customers && 'Table2'[Card ID] = "NoCard")
    VAR __Result = SUMX(__Table, [Sales])
RETURN
    __Result