Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
I'm struggling to understand how I need to approach this, so any tips would be appreciated. I can usually figure stuff out but in this case I'm lost as I can't understand what approach would be needed for the answer to this. My best guess was to try using RANK to apply a seniority over the values but that was a dead end so I'm stuck.
I have a simple table visual of data in Power BI, just showing the values of columns from a source table which looks something like this
sold-to numbercustomer nameTrained Status
123 | London | Trained |
123 | London | Not Trained |
128 | New York | Not Trained |
128 | New York | Trained |
456 | Berlin | Unknown Status |
489 | Paris | Not Trained |
489 | Paris | Not Trained |
489 | Paris | Not Trained |
654 | Madrid | Unknown Status |
789 | Rome | Trained |
879 | Oslo | Not Trained |
Its possible for there to be multiple rows where a customer can be both "Trained" and "Not Trained" (See London, New York & Paris above).
What I need to do is have the table display only a single value for each customer where the following applies
1. If both "Trained" and "Not Trained" are listed for a customer the "Trained" value takes precedence and should be the returned value
2. Otherwise return a single occurance of the relevant value so that each customer is listed only once in the table
The end result would look something like this
sold-to numbercustomer nameTrained Status
123 | London | Trained |
128 | New York | Trained |
456 | Berlin | Unknown Status |
489 | Paris | Not Trained |
654 | Madrid | Unknown Status |
789 | Rome | Trained |
879 | Oslo | Not Trained |
Solved! Go to Solution.
Try this ...
Thanks for reaching out for help.
I put in a lot of effort to help you, now please quickly help me by giving kudos.
Remeber we are unpaid volunteers and here to coach you with Power BI and DAX skills and techniques, not do the users job for them. So please click the thumbs up and accept as solution button.
If you give someone a fish then you only give them one meal, but if you teach them how to fish then they can feed themselves and teach others for a lifetime. I prefer to teach members on this forum techniques rather give full solutions and do their job. You can then adapt the technique for your solution, learn some DAX skills for next time and soon become a Power BI Super User like me.
One question per ticket please. If you need to extend your request then please raise a new ticket.
You will get a quicker response and each volunteer solver will get the kudos they deserve. Thank you !
Try this ...
Thanks for reaching out for help.
I put in a lot of effort to help you, now please quickly help me by giving kudos.
Remeber we are unpaid volunteers and here to coach you with Power BI and DAX skills and techniques, not do the users job for them. So please click the thumbs up and accept as solution button.
If you give someone a fish then you only give them one meal, but if you teach them how to fish then they can feed themselves and teach others for a lifetime. I prefer to teach members on this forum techniques rather give full solutions and do their job. You can then adapt the technique for your solution, learn some DAX skills for next time and soon become a Power BI Super User like me.
One question per ticket please. If you need to extend your request then please raise a new ticket.
You will get a quicker response and each volunteer solver will get the kudos they deserve. Thank you !
Much obliged @speedramps that worked perfectly.
I didn't think to go that route to a solution so I appreciate you taking the time. I'll know for next time 🙂
User | Count |
---|---|
117 | |
73 | |
58 | |
49 | |
48 |
User | Count |
---|---|
171 | |
122 | |
60 | |
59 | |
56 |