Conditional Formatting based on specific value for each row

[muhaiza]

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, 'target quantity' is 3,
so if 'on hand qty' >= 3 is green, and 3 < is red

but,
on the seventh row, 'target quantity' is 13,
so if 'on hand qty' >= 13 is green, and 13 < is red
 

[Samarth_18]

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

[muhaiza]

Hi @Samarth_18 ,

why it says the value cannot be determined? i'am very sure the spelling of my column is all true

[Samarth_18]

Please try this:-

measure 3 = if( sum(table[OnHand Qunatity]) >= sum(table[target quantity]) , "Green","Red")

[muhaiza]

okay, now the coding seems working, but why i can't click on the measure 3?😢

[Samarth_18]

@muhaiza Is it possible for you to share your PBIX file after removing sensitive data?

[muhaiza]

Hi @Samarth_18 ,

this is the link. Thank you!

https://drive.google.com/file/d/1PxUzDk9NABnJJukSb1DBb0UwRXOz-2Bg/view?usp=sharing 

[Samarth_18 · Accepted solution]

@muhaiza Please update your code as below:-

measure 3=
IF (
    SUM ( INF[On Hand Qty] ) >= INT ( MAX ( INF[Target Quantity] ) ),
    "Green",
    "Red"
)

Output:-

[muhaiza]

@Samarth_18 Thank youuu so much!!

[amitchandak]

@muhaiza , Create a new color measure

Switch( True() ,

[target quantity] = 3 && [OnHand Qunatity] >=3 , "Green",

[target quantity] = 3 && [OnHand Qunatity] < 3  , "Red",

[target quantity] = 13 && [OnHand Qunatity] >=13 , "Green",

[target quantity] = 13 && [OnHand Qunatity] <13 , "Red"

)

Change the value as per need.  Use in conditional formatting using field value option

How to do conditional formatting by measure and apply it on pie? : https://youtu.be/RqBb5eBf_I4

[muhaiza]

Hi @amitchandak , Thank you! 
Sorry, i'm still new to this but why it says 'cannot find name'?
do i need to declare something first?