Forum Discussion
Solved
Conditional Formatting based on specific value for each row
Hi i need help to make conditional formatting but each row depends on different value. at 'On Hand qty', the background color depends on the 'Target quantity' such as: on the fifth row, 'ta...
muhaiza Please update your code as below:-
measure 3= IF ( SUM ( INF[On Hand Qty] ) >= INT ( MAX ( INF[Target Quantity] ) ), "Green", "Red" )Output:-
Hi muhaiza ,
If on hand qty and target quantity are measure then try this:-
measure 3 = if( [OnHand Qunatity] >= [target quantity] , "Green","Red")or if those are column then use below code:-
measure 3 = if( sum(table[OnHand Qunatity]) >= sum(table[target quantity]) , "Green","Red")Now add this measure like below for conditional formatting:-
Thanks,
Samarth
Hi Samarth_18 ,
why it says the value cannot be determined? i'am very sure the spelling of my column is all truePlease try this:-
measure 3 = if( sum(table[OnHand Qunatity]) >= sum(table[target quantity]) , "Green","Red")okay, now the coding seems working, but why i can't click on the measure 3?😢
