Forum Discussion

mork's avatar
mork
Helper V
10 years ago
Solved

Help with DAX

Hello all,   I have a table that shows work per month per resource per department per country. The table looks something like bellow.     Month          Resource      ResourceDept       Work Dep...
Need Help
  • PowerDAX's avatar
    PowerDAX
    10 years ago

    Sorry - I should have been a little more clear.

     

    Whatever you want to drive the calculation of the full 100% needs to be in the ALLEXCEPT exclusion.....i.e.: 

     

    DIVIDE( [Work Total], CALCULATE( [Work Total], ALLEXCEPT( Table1, Table1[Resource], Table1[Month])), 0)

     

    If you wanted it to be treated differently based on what/if things were filtered, you could use an IF or SWITCH if you had multiple conditions....i.e. IF( ISFILTERED( Table[Column]) or IF( ISCROSSFILTERED( Table[Column]