Applying 2 filters in Same table

Hi Amit92 

Create two disconnected tables using below 2 DAX and use them in your slicers.

Cust Name = VALUES('Table'[Customer Name])

Cust Name Copy = VALUES('Table'[Customer Name - Copy])

Then alter your existing 2 measure as bleow.

Person Amt = CALCULATE(SUM('Table'[Amt]), TREATAS(VALUES('Cust Name'[Customer Name]),'Table'[Customer Name]))

Animal Amt = CALCULATE(SUM('Table'[Amt]),TREATAS(VALUES('Cust Name Copy'[Customer Name - Copy]),'Table'[Customer Name - Copy]))Now you can get the expected output.

Now you can get the expected output.

 I have attached the PBIX for reference.

If this post helps, then please consider Accept it as the solution to help the others find it more quickly. Appreciate you kudos!!

Follow me on LinkedIn!!!