Forum Discussion

kdarnt's avatar
kdarnt
Frequent Visitor
4 years ago
Solved

Getting unexpected data from measure based on the date hierarchy level

Hi, I have a date hierarchy that is performing as expected for one measure, but giving some odd results for another measure.    Here's my two charts, joined by date.    This is what the dat...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi kdarnt ,

     

    [Monthly_turnover] measure is based on [Term],[Reg_employees_month_beg] and [Reg_employees_month_end]. According to your screenshoot, I think [Monthly_turnover] will return 0 or blank when [Reg_employees_month_beg] + [Reg_employees_month_end] = 0 or [Term] = 0. So please check [Term] and [Reg_employees_month_beg] + [Reg_employees_month_end] part to get more details.

     

    Best Regards,
    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

kdarnt's avatar
kdarnt
Frequent Visitor
4 years ago

I should mention the Terms measure referenced in the turnover calculation also seems to be working fine in charts, with both the year and month parts of the date hierarchy. 

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi kdarnt ,

     

    [Monthly_turnover] measure is based on [Term],[Reg_employees_month_beg] and [Reg_employees_month_end]. According to your screenshoot, I think [Monthly_turnover] will return 0 or blank when [Reg_employees_month_beg] + [Reg_employees_month_end] = 0 or [Term] = 0. So please check [Term] and [Reg_employees_month_beg] + [Reg_employees_month_end] part to get more details.

     

    Best Regards,
    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.