ifand
1 Topic
Check to see if value in home table is greater than Limit table
Hello, I have Table 'Export'[iron] which contains a value and also has a 'Export'[UnitType] assigned to that same dataset. I have a limit table 'UnitTypeLimits'[Unit Type] and a column that has the limit 'UnitTypeLimits'[Fe]. I am looking to say use the 'Export'[UnitType] value, lets say it is "Axle", go to the 'UnitTypeLimits'[Fe] column and look for the row that contains "Axle" and check 'Export'[iron] against the 'UnitTypeLimits'[Fe] value and see if it is greater. If it is greater, return "Red" Anyone want to give it a try, I can't get the two tables to link up right. IF( AND(SELECTEDVALUE('Export'[UnitType]) == SELECTEDVALUE(UnitTypeLimits[Unit Type]), SELECTEDVALUE('Export'[Iron]) > SELECTEDVALUE(UnitTypeLimits[Fe])), )Solved810Views0likes5Comments