Drilling up and down causes measure to miscalculate

[vicjuhl]

Hi,

I have a "Line and stacked column chart" where I have a bug on the line value.

My X-axis is a time axis with possibility of drill-down. When I work in Power BI desktop I can drill up and down without problems. But when I go to the published app and drill down to day-view and then back to month-view, my measure values get fixed at given values regardless of how I then drill. This happens both in Chrome and Edge.

The measure has the following equation:

WorkHours = SUM('Dim_Employee'[NumberOfWorkHoursPrWeek) / 5 * SUM('Dim_Time'[IsWorkDay])

The measure is created in a third table "tempo_worklog" which has a connection to each of the other tables which are not connected otherwise.

The fixed values that appear after having drilled is either 0 or 34.6. The latter is exactly equal to SUM('Dim_Employee'[NoOfWorkHoursPrWeek) / 5.

I suspect that this is a bug in PowerBI.com since it runs fine in desktop, but any ideas for workarounds are most appreciated.

Kind regards, Victor

[Anonymous]

@vicjuhl,

Could you please share sample data of the above three tables so that I can test? What fields in the tempo_worklog table do you use to create relationship to the other tables? 

Regards,
Lydia

[vicjuhl]

Hi again,

I am currently unable to reproduce the bug. I have no idea why it works now.

However, I have encountered another graphical problem on the same data, posted here:
https://community.powerbi.com/t5/Issues/Line-disappears-when-I-scroll-in-combined-quot-Line-and-stac...