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(VAL...
Need Help
Jerry1985's avatar
Jerry1985
Frequent Visitor
4 years ago

Bumping up my post T_T 

 

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