Applying 2 filters in Same table

[Amit92]

Hi Team

I have a sample data as below:

I need to create 2 measures based on the category:
Person Amt should filter by Customer name and not Customer Name copy
Animal Amt should filter by Customer name copy and not Customer Name 
And i need to keep these 2 measures in the same table and the page contains 2 slicers (Customer name and Customer name copy) so that i could calculate the difference betwen them

I have added the measure as follows:

Person Amt = CALCULATE(SUM('Table'[Amt]), REMOVEFILTERS('Table'[Customer Name - Copy]))

Animal Amt = CALCULATE(SUM('Table'[Amt]),REMOVEFILTERS('Table'[Customer Name]))

and added both the measures in the single table, when i select any one of the slicer the measures are working fine but when i select both of them it is giving me as blank


Can you guys help me please?

Thanks
Amit

[NaveenGandhi · Accepted solution]

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

[Amit92]

Wow! Geniously solved

Thanks Naveen