Forum Discussion
Filter text in Power Bi using DAX
Thank you so much,it works.
In addition to this, I need some more help. I want to display in in one table visuals the following result: show only customer_ids that satisfy this condition: if there is a row with the text 'Non ref replaced' and for the same customer a row 'Standard price', show only this row 10000 Non Ref replaced.
In other table visual : if there is only Non Ref or NonRef and no other values in Key words column show only the custmer id only once.
| customer_id | KeyWords |
| 10000 | Standard Price |
| 10000 | Non Ref |
| 10000 | Non Ref replaced |
| 10000 | NonRef |
Any assistance would be appreciated.
I need to understand more the new request.
In case you have the above example, customer_id 10000 with the four keywords, can you tell me what is the value to prioritize, something like this:
customer_id KeyWords 10000 Standard Price 3 10000 Non Ref 1? 10000 Non Ref replaced 2 10000 NonRef 1?
Did it work ? 👍 A kudos would be appreciated 📢 Mark it as a solution to help spreading knowledge
