OR Logic With Matching count in Power BI Desktop using DAX

[Sabeer93]

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 ID in the card visual. Please can someone help me with the DAX logic. 

@dax 

[Sabeer93]

@Take3 ,@daxhelp 
Please can you look into the attached file. I'm able to get the output using the Matrix visual but need to get the output in Card Visual 

[Sabeer93]

Transacation ID you use the different for each Product. In my many products have the same transacations id 

[Take3]

Please provide a data sample, showing how multiple products are sharing the same Transaction ID.

[Sabeer93]

https://drive.google.com/file/d/1o9Zq2B5u4I0i8nMVys0EMIEwSz1EkbiB/view?usp=drive_link

[Take3]

Thanks for sharing!  Very helpful.

This is what you need.

Regards,

Nathan

[Sabeer93]

No, you didnt get my requirement, The requirement is to show only matching count of display products with the same transaction id 

Whenever they select the 2 different records from the Product table its should check the matching count of transaction id and its should show the matching record count 

[Take3]

My apologies.  I still do not understand.

1) If the user selects Brush & Eggs, what should the correct result be?

2) If the user selects Brush, Eggs & Beer, what should the correct result be?

3) If the user selects Brush, Tooth Paste & Pencil, what should the correct result be?

I believe I will understand better once you answer these 3 scenarios for me.

Regards,

Nathan

[Sabeer93]

) If the user selects Brush & Eggs, what should the correct result be? Zero 

2) If the user selects Brush, Eggs & Beer, what should the correct result be? Two 

3) If the user selects Brush, Tooth Paste & Pencil, what should the correct result be? Three 

[Take3]

I guess I was wrong.  Still struggling to understand...

1) Brush & Eggs = 0 because there are 0 matches between the 2 transaction IDs?

2) Brush, Eggs & Beer = 2 because ???

Each of these products has a different Transaction ID.

I would think that because there are no matches, this would be 0 also.

Can you help me understand how the result should be 2?  

3) Brush, Tooth Paste & Pencil all share the same Transaction ID.

So there are 3 products that share the same matching ID.

I think believe that's why the answer is 3.  Is that correct?

[Sabeer93]

Yes.. you are correct. can you help me with the logic 

[Sabeer93]

@Take3  @Daxhelp 

Any luck with the solution ?

[Take3]

@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

[Sabeer93]

Hello Nathan, @Take3  

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

[WinterMist · Accepted solution]

@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

[Take3]

@Sabeer93 

Please try the following.

Hope this is helpful to you.

Nathan