Forum Discussion
H_insight
Helper V
Helper VCount with condition per customer per id
Hiya, I am trying to write a measure to count the Products per customer and per id, where the "Product" column = "Product 1" and does not contain any "Product 2" for the same ID. here s my ...
Hi,
thank you for your feedback.
I am not sure if I understood your question correctly, but please check the below picture and the attached pbix file whether it suits your requirement.
H_insightHelper V
Helper VHi Jihwan_Kim ,
I am still getting the same result for 3 records, and my goal is to show only 2 records
Goal:
Jihwan_Kim
Super User
Super UserHi,
thank you for your feedback.
I am not sure if I understood your question correctly, but please check the below picture and the attached pbix file whether it suits your requirement.
- H_insight
Jihwan_Kim Super Star🌟!! Thank you very much. I have to say, formatting DAX does help a lot in understanding the logic behind the code. 👍