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]

kcantor's avatar
kcantor
Community Champion
10 years ago

I would do multiple calculations. First, Sum the hours.

Total Hours = SUM(Table[Hours])

Total Hours Last Month = CALCULATE([Total Hours], DATEADD(Date Table[Date Key], -1, Month))

Hours Growth % = DIVIDE([Total Hours], [Total Hours Last Month]) -- be sure to format this as a percentage in the ribbon.

Use your Matrix Rows and Visual Axis to seperate by month.

mork's avatar
mork
Helper V
10 years ago

kcantor Sorry but I don't understand what this will do exactly. What should I put at the DATEADD function?

And also if I understand correctly this will show me the previous month. which is good, but how can I get the percentage per resource too and not for all the resources combined?