Forum Discussion

Wittig_Lyon's avatar
Wittig_Lyon
New Member
2 years ago

Measure giving total for a column calculation

 

The picture is showing the measure I wrote,

the problem I'm encountering is; I'm pulling month name and this measure into a table. The measure is bringing same value for all the months and the total. 

ex. 

jan 8.3%
feb 8.3% 

up until December and the total 8.3%

 

any help?

1 Reply

  • DallasBaba's avatar
    DallasBaba
    Icon for Skilled Sharer rankSkilled Sharer
    2 years ago

    Wittig_Lyon you need to ensure that your measure is evaluated at the month level in other to get different values for each month.

    Attrition Rate Month Dummy = 
VAR Term = TOTALMTD([Terminations], 'dwDimeDate'[DateKey])
VAR StartHeadCount = CALCULATE([starttomonth], ALL('WDFactEmployeeOrg'[TerminationCategory]))
VAR AvgHeadCount = CALCULATE((StartHeadcount + [Active Employee Count]) / 2, ALL('WDFactEmployeeOrg'[TerminationCategory]))
VAR Division = DIVIDE(Term, AvgHeadCount) * 12

-- Calculate the attrition rate for each individual month
VAR MonthAttritionRate = IF(Division = 0, BLANK(), Division)

RETURN
MonthAttritionRate

    The MonthAttritionRate calculate for each individual month. This should give you different values for each month when you use it in a table alongside the month names. If you still see the same value for all months and the total, you may need to check the context in which the table is placed or ensure that the month name is part of the table's row context.

    Did I answer your question? Mark my post as a solution!
    Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!


      Let me know if this work
    @ me in replies, or I'll lose your thread!!!  


    Thanks