Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
Check it out now!Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more
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.
A | B | C |
123 | redwhitegreen | True |
456 | yellowpurple | False |
123 | redblue | True |
456 | blueblack | False |
123 | greenblue | True |
456 | redblack | False |
789 | whitesilver | True |
Hi @Anonymous ,
Please try:
Measure =
var _a = COUNTROWS(FILTER(ALL('Table'),[A ]=SELECTEDVALUE('Table'[A ])&&CONTAINSSTRING([B],"white")))
return _a>0
Final output:
Best Regards,
Jianbo Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
hi @Anonymous ,
How about this:
Here the code for the measure:
Measure = IF ( CALCULATE ( CONTAINSSTRING ( MAX ( 'Table'[B] ), "white" ), ALLEXCEPT ('Table', 'Table'[A] ) ), true, false )
Let me know, if this helps 🙂
/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/
Did I answer your question❓➡️ Please, mark my post as a solution ✔️ |
Also happily accepting Kudos 🙂 |
Feel free to connect with me on LinkedIn! | |
#proudtobeasuperuser | |
Doesn't look like all distinct values of Column A received a TRUE from my end when they should have.
Hi @Anonymous,
Please could you share the data and the screenshot showing which ones do not receive a true though they should have?
Thanks
/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/
Did I answer your question❓➡️ Please, mark my post as a solution ✔️ |
Also happily accepting Kudos 🙂 |
Feel free to connect with me on LinkedIn! | |
#proudtobeasuperuser | |