Checking values for multiple columns

[Desyn]

Hi,

I need to check a table of data to make sure that the values in all columns are all equal to 40. So in the table below, only row 1 would meet this criteria. Row 2 sums to the same total, but isn't compliant since columns 4 & 5 do not equal 40. Row 3 clearly does not meet the critera.

40	40	40	40	40
40	40	40	38	42
25	25	25	25	25

I then need to take this a stage further and be able to specifiy the value that each row is checked against. So for example, rows 1 & 2 need to have 40 in every column, but row 3 needs to have 25 in each column. Now, in the table above, rows 1 & 3 are compliant, but row 2 still iisn't.

Thanks in advance for any help.

[Ahmedx]

if you need a measure, write it like this

[tackytechtom]

Hi @Desyn ,

Maybe something like this? 🙂

Here the measure:

Measure = 
VAR _col1value = SELECTEDVALUE('Table'[Column1])
VAR _col2value = SELECTEDVALUE('Table'[Column2])
VAR _col3value = SELECTEDVALUE('Table'[Column3])
VAR _col4value = SELECTEDVALUE('Table'[Column4])
VAR _col5value = SELECTEDVALUE('Table'[Column5])
RETURN
IF ( 
    _col1value = _col2value && _col1value = _col3value && _col1value = _col4value && _col1value = _col5value, "compliant", 
    "noncompliant"
)

Hope this helps 🙂

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/

[Ahmedx · Accepted solution]

pls try this

[Desyn]

That's great, thank you for your help.