IanBradley
9 years agoRegular Visitor
Status:
New
Issue with USERELATIONSHIP DAX function when querying Analysis Services from PowerBI
I have a Tabular data model with [Calendar] and [Incidents] data sets. The [Incidents] data set has [Create Date] and [Resolve Date]. I create a relationship for [Calendar].[Date] -> [Incidents].[Create Date] (this is marked as active) and a relationship for [Calendar].[Date] -> [Incidents].[Resolve Date] (marked as inactive). I then create 2 measures; Created and Resolved. Both use the CALCULATE and USE RELATIONSHIP functions e.g. Created:=CALCULATE(sum([Incidents],USERELATIONSHIP('Incidents'.[Create Date] = 'Calendar'.[Date]). The results are perfect when querying the Tabular data model via Excel. However, PowerBI will not show the correct totals for the Inactive relationship when there are more than say 20 items in the visual. e.g. if you want a tabular visual that shows Resolved by [Assigned Group], and there are 50 assignment groups, the total is < than actual total. I have tried to replicate with the same data in SQL and Excel and it works just fine. Only Tabular data models are the problem. Please help
1 Comment
- fbcideas_migusrNew MemberStatus added:New
Recent ideas
Power BI UX Suggestion: Preserve Selection When Switching Between Report and Model Views
When developing a Power BI report, if I select a visual in Report View and then switch to Model View, the selected table/column context is lost and everything becomes unselected. This can be inconv...Murtaza_Ghafoor1 hour agoSuper UserNew2Views0likes0CommentsPower BI UX Suggestion: Preserve Selection When Switching Between Report and Model Views
When developing a Power BI report, if I select a visual in Report View and then switch to Model View, the selected table/column context is lost and everything becomes unselected. This can be inconv...Murtaza_Ghafoor1 hour agoSuper UserNew3Views0likes0CommentsDefault Scrollable Time-Series Charts to Most Recent Data
Currently, Power BI time-series charts always open scrolled to the earliest (leftmost) date by default, which is inconvenient for reports where users are interested in the most recent (rightmost) dat...CStillwell2 hours agoNew MemberNew3Views0likes0CommentsPower BI Desktop Data Load: Can We Get Better Progress Visibility?
One UX improvement I’d really like to see in Power BI Desktop is better visibility when loading large datasets from Power Query. Currently, when Power Query finishes processing and the data starts l...salmansaifee773 hours agoRegular VisitorNew15Views0likes0CommentsImprove support for calculated tables on remote semantic models
When a report is connected to a remote semantic model, Power BI Desktop allows users to create calculated tables and calculated columns based on that remote model. The issue is that this architectur...alaeddinegaaya7 hours agoNew MemberNew10Views0likes0Comments