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

sameergupta60's avatar
sameergupta60
Helper IV
4 years ago

Dear Team,

 

this solution work on the tower level summary.

BWNEWBICFzone = VAR _maxrcc = MAXX(SUMMARIZE('L1','L1'[Code33],"rcc",[RCCCount]),[rcc])
VAR _colour = IF([RCCCount]-7>[BWcount]&&[RCCCount]=_maxrcc,"Red","Green") RETURN _colour

but when we add the same logic to the project summary it is not showing results properly.

 

if we see at the project level total of 13 the block work must be red but it is showing green.

 

Can please share logic for project level

 

 

 

 

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi sameergupta60 ,

 

Would you please consider sharing a sample file for testing, that would be helpful, thanks in advance!

 

Best Regards,
Gao
Community Support Team

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 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
        3 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