Forum Discussion

Desyn's avatar
Desyn
Regular Visitor
2 years ago
Solved

Checking values for multiple columns

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.

 

4040404040
4040403842
2525252525

 

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.

Need Help

4 Replies

    • Desyn's avatar
      Desyn
      Regular Visitor
      2 years ago

      That's great, thank you for your help.

  • tackytechtom's avatar
    tackytechtom
    Most Valuable Professional
    2 years ago

    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/