Forum Discussion

Sabeer93's avatar
Sabeer93
Frequent Visitor
3 years ago
Solved

OR Logic With Matching count in Power BI Desktop using DAX

Hello Power BI Team,  Logic: We have slicer to filter the Product column, When the users selects the Multiple Products from the slicer . Its should the show the matching count of the Transacation ...
@Dax
@Daxhelp
  • WinterMist's avatar
    WinterMist
    3 years ago

    Sabeer93 

     

    Thanks for clarifying scenario #2.

    Hopefully I am understanding correctly now.

     

    Please create the following 2 measures:

     

     

     

    Test Scenario 1 =

    Brush & Eggs should return 0 because there are 0 matching Transaction ID's selected.

     

     

    Test Scenario 2 =

    Brush, Eggs & Beer should return 0 because there are 0 matching Transaction ID's selected.

     

     

    Test Scenario 3 =

    Brush, Tooth Paste & Pencil should return 3 because there are 3 matching ID's selected.

     

     

     

    In summary, for the 3 scenarios discussed, the Card Visual is returning the desired result; unless I have completely misunderstood yet again.

     

    Let me know if there are other scenarios for which the Card Visual does not return the desired result.

     

    Hope this is helpful to you.

     

    Regards,

    Nathan

Sabeer93's avatar
Sabeer93
Frequent Visitor
3 years ago

Take3  @Daxhelp 

Any luck with the solution ?

Take3's avatar
Take3
Regular Visitor
3 years ago

Sabeer93 

 

I am still confused by scenario #2.

IF Brush, Eggs & Beer are selected THEN you're saying the expected result is 2.

 

 

 

This doesn't make sense to me.  For this scenario there are zero matching Transaction IDs.  In this case, I would expect the result to be "zero".

Can you help me understand how you are calculating the result as "2"?

 

Regards,

Nathan

  • WinterMist's avatar
    WinterMist
    Impactful Individual
    3 years ago

    Sabeer93 

     

    Thanks for clarifying scenario #2.

    Hopefully I am understanding correctly now.

     

    Please create the following 2 measures:

     

     

     

    Test Scenario 1 =

    Brush & Eggs should return 0 because there are 0 matching Transaction ID's selected.

     

     

    Test Scenario 2 =

    Brush, Eggs & Beer should return 0 because there are 0 matching Transaction ID's selected.

     

     

    Test Scenario 3 =

    Brush, Tooth Paste & Pencil should return 3 because there are 3 matching ID's selected.

     

     

     

    In summary, for the 3 scenarios discussed, the Card Visual is returning the desired result; unless I have completely misunderstood yet again.

     

    Let me know if there are other scenarios for which the Card Visual does not return the desired result.

     

    Hope this is helpful to you.

     

    Regards,

    Nathan

  • Sabeer93's avatar
    Sabeer93
    Frequent Visitor
    3 years ago

    Hello Nathan, Take3  

    Sorry for the confusion. the answer is zero not two. can you help me with the logic