Forum Discussion

Raivo_S's avatar
Raivo_S
Frequent Visitor
7 years ago
Solved

DAX Filter on same Table

Hello, I am struggling to create to create formula, that would filter table based on values from the same table. I created this table of individual sales as an example: It shows client who bo...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    7 years ago

    Hi,

    This calculated column formula works

    =if(Data[Product]="BBB",CALCULATE(COUNTROWS(Data),FILTER(Data,Data[Client_ID]=EARLIER(Data[Client_ID])&&Data[Product]="AAA"&&Data[Seller]=EARLIER(Data[Seller]))),BLANK())

Ashish_Mathur's avatar
Ashish_Mathur
Super User
7 years ago

Hi,

This calculated column formula works

=if(Data[Product]="BBB",CALCULATE(COUNTROWS(Data),FILTER(Data,Data[Client_ID]=EARLIER(Data[Client_ID])&&Data[Product]="AAA"&&Data[Seller]=EARLIER(Data[Seller]))),BLANK())

  • Raivo_S's avatar
    Raivo_S
    Frequent Visitor
    7 years ago

    It worked, thank you!

    I tried to create those filters using function EARLIER previously but made a mistake in my formula. Just tried to write another one from the beginning and it worked perfectly!

    I will leave this topic open until I make my Measure, then I will share my solution and close this topic.