Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have data that among other things contains names and Offer/Reject action. I want to find how many names are in each action Reject or Accept. I can create 2 seperate measures for both actions and do distinctcount to count each individually. But that results in some doublecounting as some name are first reject and then offered so are counted seperately.
I want to count them seperately only but need to remove if they were in the other action before.
Take John as an example below. He appears 4 times, 2 reject and 2 offered. I created a measure of Distinctcount and filtered by action. so I get 1 in offer and 1 in reject. I only want 1, based on the newest entry.
Thanks!!
Date | Name | Action |
1 Feb | John | Reject |
1 Feb | John | Reject |
2 Feb | Adam | Reject |
2 Feb | Robert | Offer |
3 Feb | John | Offer |
4 Feb | Mike | Reject |
4 Feb | Mike | Offer |
5 Feb | John | Offer |
Solved! Go to Solution.
Hi,
I am not quite sure which action does Mike belong to. On the same day, Mike's result is Reject and Offer.
I guess Mike belongs to both, and the below calculation shows like this.
Please check the attached pbix file.
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Hi,
I am not quite sure which action does Mike belong to. On the same day, Mike's result is Reject and Offer.
I guess Mike belongs to both, and the below calculation shows like this.
Please check the attached pbix file.
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Sorry for not making the sample properly. Mike belongs to the Offered action. I think date/time datatype can solve that. The solution itself if working. Thank You!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
100 | |
99 | |
80 | |
77 | |
66 |
User | Count |
---|---|
134 | |
106 | |
104 | |
85 | |
73 |