Forum Discussion
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...
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 ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks, yeah I finally put it together that the values were being calculated as 0 and infinity, which was messing up the axis of the chart.