Crashing the Available Ressources with Conditional Formatting of a calculation group

[Anonymous]

Hello, 

I'm trying to format a card visual (the new one) which includes a field parameter and is filtered using a calculation group item. 

The visual is filtered like this to show the desired outcome. The Filter "Spalte der Berechnungsgruppe" is a calculation group. 
Value4 and Value5 are filtered to show the correct value of AE/Rev(field parameter). 

The visual looks like this 

So now I want to use conditional formatting to make the percentage values gree or red. For this is have created a Formatting Measure like this 

Formating MEasure ( DELTA AV_Anzahl) =

CALCULATE([distinct_offer_count],'Berechnungsgruppe'[Spalte der Berechnungsgruppe] = "Δ Month vs. Ø3M"

 )
The problem is that I get the "visual has exceeded available resources" error. 

Does anyone has an idea on how to fix this?

[Anonymous]

Hi, @Anonymous 

You can find the solution in the related cases below. The main way is to optimize your DAX or to increase your computer RAM. in Power BI service you can use premium or optimize your DAX:

Solved: Service: Visual has exceeded available resources. ... - Microsoft Fabric Community

Troubleshooting tile errors - Power BI | Microsoft Learn

how to fix visual has exceeded the available resource. - Microsoft Q&A

Best Regards

Jianpeng Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.