Forum Discussion

sameergupta60's avatar
sameergupta60
Helper IV
4 years ago
Solved

Conditional formatting help on count

Dear Team,   Need help with conditional formatting.       if my RCC is on  max count then block work conditional formatting -7 with any red cell color   Example = 26-7 = 19 but the curr...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi sameergupta60 ,

     

    Please try this measure:

    Measure = 
VAR _maxrcc = MAXX(SUMMARIZE('Table','Table'[Tower Name],"rcc",[RCC]),[rcc])
VAR _colour =
IF([RCC]-7>[Block Works]&&[RCC]=_maxrcc,"Red","Green")
RETURN
_colour

     

    Best Regards,
    Gao
    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

    How to get your questions answered quickly -- How to provide sample data

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi sameergupta60 ,

 

These two visual effects have different calculation contexts, and you need to modify the formula according to the actual situation. Please try this measure.

BWNEWBICFzone = 
VAR _maxrcc =
    MAXX ( SUMMARIZE ( 'L1', 'L1'[ProjectName], "rcc", COUNT('L1'[New RCC]) ),[rcc] )
VAR _colour =
    IF ( COUNT('L1'[New RCC]) - 7 > COUNT('L1'[BW2])&&COUNT('L1'[New RCC])=_maxrcc, "Red", "Green" )
RETURN
    _colour

Best Regards,
Gao
Community Support Team

sameergupta60's avatar
sameergupta60
Helper IV
4 years ago

hi,

Example

we have 1 project & 4 towers 

if my RCC is on 32 towers then block work should be on 25 floors is green or red (we wrote conditional formatting measures tower-wise)

 

When we add the total to the project level RCC 128 no then block work 100 no means it is green ( but with your measures it is showing red)

 

please help