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.
Hi experts,
I am trying to mark all the rows that that are invalid.
Please help me with Dax or M as I fairly new.
Col A | Col B | Mark |
WWW | Don't Consider | X |
WWW | Consider | X |
WWW | Consider | X |
ABC | Don't Consider | X |
ABC | Consider | X |
XYZ | Consider | OK |
If in col B, if I find any value as "Don't Consider", then I should be able to ignore the whole bunch of rows with that ID.
So the result should be as column 'Mark'.
Thanks in advance!
Solved! Go to Solution.
Try this..
Try this..
can I do the same condition but make in a table without add X and OK only filter the table result as a table?
Thanks a lot for the quick response VasTg.
The DAX worked in the way I want. But as I was looking at the records, I might need to add more condition in the future.
But for now, it serves my purpose.
Appreciated!! And keep up the good work 🙂
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
101 | |
86 | |
64 |