True/False column after evaluating a set of rows

[Anonymous]

Hi Everyone,

I need to create a Column in DAX to create the Bold Column in below Table. It would evaluate if each row# has a True Match in "Match?" Column, then new column will be True, otherwise False

Row#	Attribute	ValueBase	ValueCompare	Match?	All Values in same Row# Match?
1	1	A	A	True	False
1	2	A	B	False	False
1	3	B	B	True	False
2	1	A	A	True	True
3	1	B	B	True	False
3	2	C	A	False	False
4	1	A	A	True	True
4	2	A	A	True	True
4	3	C	C	True	True
4	4	B	B	True	True

Thanks

[SpartaBI]

@Anonymous 
solution file: True False column after evaluating a set of rows 2022-08-03.pbix

Write this calculated column:

Result Column = 
VAR _row = 'Table'[Row#]
VAR _values = 
    CALCULATE(
        DISTINCTCOUNT('Table'[Match?]),
        'Table'[Row#] = _row,
        REMOVEFILTERS('Table')
    )
VAR _result = 
    IF(_values = 1,  TRUE(), FALSE() )
RETURN
    _result

      

Showcase Report – Contoso By SpartaBI

[Anonymous]

Hi @SpartaBI ,

Thanks for your support on this. When I try your solution in my sample file/data I posted earlier it works perfectly. However, when I try this in my dataset (which it has the same structure/logic than the sample) for some reason is not giving the same output. Ive attached a portion of the dataset with both the sample data and this one with the solution.

SamplePBIX 

Which could be the issue? When I read the logic behind your column I see that the output should be correct for my dataset as it is in the sample data.

Thanks,

[SpartaBI]

@Anonymous if all columns for row number are false, you want to get false?
Cause that's not what I did but I will add this logic if that is what you meant.

[Anonymous]

Hi Sparta,

The outcomes should be:

If all Row# are False, then False
If some Row# are False and others are True, then False
If all Row# are True, then True

[SpartaBI · Accepted solution]

@Anonymous like this?

Result Column = 
VAR _row = 'Table (2)'[RowNumber]
VAR _test_for_true = 'Table (2)'[Is Predecessor Plan inside External Dependencies]
VAR _values = 
    CALCULATE(
        DISTINCTCOUNT('Table (2)'[Is Predecessor Plan inside External Dependencies]),
        'Table (2)'[RowNumber] = _row,
        REMOVEFILTERS('Table (2)')
    )
VAR _result = 
    IF(_values = 1 && _test_for_true,  TRUE(), FALSE() )
RETURN
    _result

      

Showcase Report – Contoso By SpartaBI

[Anonymous]

The test for true was the key! Ty!

[SpartaBI]

my pleasure 🙂
P.S. Kudos are always welcome 😀 
Check out my showcase report - got some high level stuff there. Sure you will find there a lot of cool ideas. Please give it a thumbs up over there if you liked it 🙂
https://community.powerbi.com/t5/Data-Stories-Gallery/SpartaBI-Feat-Contoso-100K/td-p/2449543

[SahityaYeruband]

Hi Sparta,
Can you please breakdown how - _test_for_true

is working?