Forum Discussion

Jerry1985's avatar
Jerry1985
Frequent Visitor
4 years ago

Slicer issues

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 
Need Help

3 Replies

    • v-easonf-msft's avatar
      v-easonf-msft
      Community Support
      4 years ago

      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's avatar
        Jerry1985
        Frequent Visitor
        4 years ago

        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...