msimanek's avatar
msimanek
Regular Visitor
3 years ago
Status:
Needs Info

Measure using USERELATIONSHIP works in Power BI Desktop but not in Power BI Service

Hi Community,   Few days ago, one particular issue appeared in our report's measure on Power BI Service.   Measure is using inactive M:N relationship which is activated in measure using USERELATI...
Data Modeling
Report Server
Reports
msimanek's avatar
msimanek
Regular Visitor
2 years ago

Hi,

 

I invesitgate this issue further and found that issue could be "null" values on both sides of relationship.

 

I tried to create sample which would mimic our reports:

 

There are cases with "blank" values in IDs on both sides of relationship, if Blanks are selected that sum for those "blank" records in LEFT_TABLE are also added to the SUM.

 

Since we haven't done any changes in formulas on our side and data had those null values historicaly, I guess there could be change how relationship works in general, that means "blanks" were excluded by default and now they are included by default?

So for this sample, before the issue measure would return value 65 (excluded blanks) instead of 265 (included blanks).

 

Could anyone confirm or clarify how blanks are handled in those relationships by default?

 

I'm including sample pbix file: https://drive.google.com/file/d/1FrvYI7hLkljWT63MAZFpSgOp92w-e_s9/view?usp=drive_link .

 

Thanks,

Michal

Completed Ideas