topic Re: OR Logic With Matching count in Power BI Desktop using DAX in DAX Commands and Tips

OR Logic With Matching count in Power BI Desktop using DAX

Sabeer93 — Fri, 28 Jul 2023 19:07:54 GMT

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

Re: OR Logic With Matching count in Power BI Desktop using DAX

Take3 — Fri, 28 Jul 2023 20:31:39 GMT

Sabeer93

Please try the following.

Hope this is helpful to you.

Nathan

Re: OR Logic With Matching count in Power BI Desktop using DAX

Sabeer93 — Fri, 28 Jul 2023 20:57:53 GMT

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

Re: OR Logic With Matching count in Power BI Desktop using DAX

Take3 — Fri, 28 Jul 2023 21:04:06 GMT

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

Re: OR Logic With Matching count in Power BI Desktop using DAX

Sabeer93 — Fri, 28 Jul 2023 21:20:38 GMT

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

Re: OR Logic With Matching count in Power BI Desktop using DAX

Sabeer93 — Fri, 28 Jul 2023 21:49:39 GMT

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

Re: OR Logic With Matching count in Power BI Desktop using DAX

Take3 — Fri, 28 Jul 2023 21:56:12 GMT

Thanks for sharing! Very helpful.

This is what you need.

Regards,

Nathan

Re: OR Logic With Matching count in Power BI Desktop using DAX

Sabeer93 — Fri, 28 Jul 2023 22:08:01 GMT

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

Re: OR Logic With Matching count in Power BI Desktop using DAX

Take3 — Fri, 28 Jul 2023 22:31:14 GMT

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

Re: OR Logic With Matching count in Power BI Desktop using DAX

Sabeer93 — Fri, 28 Jul 2023 22:43:52 GMT

) 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

Re: OR Logic With Matching count in Power BI Desktop using DAX

Take3 — Fri, 28 Jul 2023 23:34:41 GMT

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?

Re: OR Logic With Matching count in Power BI Desktop using DAX

Sabeer93 — Sat, 29 Jul 2023 02:04:09 GMT

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

Re: OR Logic With Matching count in Power BI Desktop using DAX

Sabeer93 — Sun, 30 Jul 2023 16:39:40 GMT

Take3 @Daxhelp

Any luck with the solution ?

Re: OR Logic With Matching count in Power BI Desktop using DAX

Take3 — Mon, 31 Jul 2023 17:43:36 GMT

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

Re: OR Logic With Matching count in Power BI Desktop using DAX

Sabeer93 — Tue, 01 Aug 2023 16:47:05 GMT

Hello Nathan, Take3

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

Re: OR Logic With Matching count in Power BI Desktop using DAX

WinterMist — Wed, 02 Aug 2023 21:28:42 GMT

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