topic Re: Return True or False if one row from column B contains a certain string for all values of column A in DAX Commands and Tips

Return True or False if one row from column B contains a certain string for all values of column A

Anonymous — Tue, 09 May 2023 04:10:12 GMT

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

Re: Return True or False if one row from column B contains a certain string for all values of column A

tackytechtom — Tue, 09 May 2023 05:14:49 GMT

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/

Re: Return True or False if one row from column B contains a certain string for all values of column A

Anonymous — Tue, 09 May 2023 18:23:23 GMT

Doesn't look like all distinct values of Column A received a TRUE from my end when they should have.

Re: Return True or False if one row from column B contains a certain string for all values of column A

tackytechtom — Wed, 10 May 2023 02:21:57 GMT

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/

Re: Return True or False if one row from column B contains a certain string for all values of column A

v-jianboli-msft — Mon, 29 May 2023 07:27:15 GMT

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.