Slicer issues

[Jerry1985]

Hello! I previously got help with my query on using a measure to calculate my average operational days. 

The formula the community helped me with was this 

Ops Days(Act) = AVERAGEX(VALUES('PowerBI Data'[Country2]),CALCULATE(SUM('PowerBI Data'[Total]),'PowerBI Data'[Revenue Reference]="OpsDay_",'PowerBI Data'[Actual / Plan]="Act",SWITCH('PowerBI Data'[Country],"SG",TRUE(), "MY",TRUE(),"TH",TRUE(),"PH",TRUE(),"VN",TRUE(),"ID",TRUE())))

However, when I try to slice/filter by Product1 or 2. The result is Infinity.

How can I get powerbi to recognize that Operational days can be used to beyond slicing by country? 

e.g. Revenue (Express) / Ops Days 

[Jerry1985]

Bumping up my post T_T 

[v-easonf-msft]

Hi, @Jerry1985 

Yur formulas and screenshots confuse me.

Can you directly share your sample data and expected results?

Best Regards,
Community Support Team _ Eason

[Jerry1985]

Thanks for reaching out!
My sample data is below. 

so my expected outcome is a calculated ADNR 4,176k (Express).

I'm trying to get powerbi to calculate the same ADNR of $x,xxxk (Domestic) 

But i can't get it to recognize that the opsdays calculation can be used interchangeably between Express and Domestic. 

Not sure if this made sense...