Forum Discussion

Amit92's avatar
Amit92
Regular Visitor
2 years ago
Solved

Applying 2 filters in Same table

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





Need Help
  • NaveenGandhi's avatar
    NaveenGandhi
    2 years ago

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





2 Replies

  • NaveenGandhi's avatar
    NaveenGandhi
    Icon for Memorable Member rankMemorable Member
    2 years ago

    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's avatar
      Amit92
      Regular Visitor
      2 years ago

      Wow! Geniously solved

      Thanks Naveen