Issues with Conditional Formatting and Calculation Groups

[marcofalzone]

Hi community, I developed a model with some conditional formatting, and I'm quite happy with it.

Since the number measure is quickly growing, I've started to implement Calculation Groups, to make it more efficient, and it actually works also with the new implementation, but I'm struggling with conditional formatting for a couple of cases.

Please, could somebody have a look to my samples and suggest a fix? I do really appreciate any contribution.

Thank you

Marco

Download Sample Model

https://www.dropbox.com/scl/fi/4sju5841r4m3afq7tewdo/Help_CalcGroups.zip?rlkey=v65nx5eshluxkz310ta7j...

[Kishore_KVN]

Hello @marcofalzone ,

What is the condition you want to implement in this conditional formatting. Please explain it. 

[marcofalzone]

Thanks @Kishore_KVN for your kind and prompt reply, and sorry for being too vague.

The attached model shows the conditions, but thanks for asking.

The conditional formatting is applied to any of the field and/or measures selected on the visual, tipically the P&L Row description and any of the amounts (Actual, Budget, Forecast), as shown in the example.

The condition I need to apply is the same achieved without calculation groups: it's a condition based on "Rules", and based on the field measure called "PL SubTot Color".

• If the value of the fiels is 0, it means that the P&L Row is a Running Total, and the background color of the field becomes light blue.
• If the value of the fiels is 0, it means that the P&L Row is a SubTotal, and the background color of the field becomes light grey.

I was not able to figure out how to make it work that logics with calculation groups activated.

Thanks again for your valuable contribution. Please, let me know if I'm missing some relevant information (and sorry in advance for that).

Marco F.