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 ...
Need 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/