In this example I am trying to return true or false in column C based on whether one of the rows in column B contains the string "white" within a larger string for all distinct values within column A.
Hi @nabraham623 ,
var _a = COUNTROWS(FILTER(ALL('Table'),[A ]=SELECTEDVALUE('Table'[A ])&&CONTAINSSTRING([B],"white")))
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
hi @nabraham623 ,
How about this:
Here the code for the measure:
MAX ( 'Table'[B] ), "white" ), ALLEXCEPT ('Table', 'Table'[A] )
Let me know, if this helps 🙂
Proud to be a Super User!
Doesn't look like all distinct values of Column A received a TRUE from my end when they should have.
Please could you share the data and the screenshot showing which ones do not receive a true though they should have?
Take a look at the September 2023 Power BI update to learn more.
Join Microsoft Reactor and learn from developers.