Forum Discussion
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 ID in the card visual. Please can someone help me with the DAX logic.
dax
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
15 Replies
Transacation ID you use the different for each Product. In my many products have the same transacations id
Please provide a data sample, showing how multiple products are sharing the same Transaction ID.
