Measure works in Excel PP - but not in PowerBI

[smaur]

Hi All,
I have a fact table of 'events' with a dates of occurrence for each event and other data about the events. In PowerPivot I have a measure to count the number of occurrences of events between two dates as filtered by a Date Slicer. The measure relies on the UseRelationship function because I need to have the relationship between fact table and date table normally inactive.

Here is that measure:
TotalEvents:=Calculate(COUNTROWS(fProdStop),USERELATIONSHIP(DCalendar[Date],fProdStop[FromDate]))

This works fine in Excel. The problem is I can't get it to work in Power BI. My resulting bar chart for the event count plotted against the month on the x axis shows only one bar, with the word (blank) beneath the bar. The value plotted on that one bar is the total number of events for every month in one lump sum.

Any ideas of what is happening here?

 

[ImkeF]

Check the connection type in PowerBI between your tables. They me be set to bidirectional which could mess up your results.