Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Understanding Context Between Average and Sum - Remove Filters

Hello,   I am trying to resolve one issue, where I want to remove a context from my dax. I tried ALLEXCEPT but didnt' work. Here is the example: 1. Person A got 2 pay changes (11.1 % and -10%...
Need Help
  • v-easonf-msft's avatar
    v-easonf-msft
    4 years ago

    Hi, Anonymous 

    Is this what  you want?

     

    I didn't do much correction, just divide the two measures you've created.

    Avg2. % Pay Changes = DIVIDE(HRIS_TD_COMP_BY_NETWORK_SUMMARY[Sum % Pay Changes],[# of EE Receiving Pay Changes])

     

    Best Regards,
    Community Support Team _ Eason

Anonymous's avatar
Anonymous
Not applicable
4 years ago

You are absolutley right. We are having internal discussion about exactly this topic. My question is: if we go through this use case, then how can we achieve the desired result? Thanks!

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
4 years ago

I would start with a better definition of the business problem - what issue are you actually trying to solve?

Then I would cleanup my data, and provide good timestamps

Lastly I would work with the business users on the UX. They often cannot articulate well what they want but when you show them a prototype they can quickly tell why what you did is not what they wanted. After a couple more iterations you will hoepfully arrive at an acceptable solution.

 

The first step is absolutely crucial.