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
Restore Shape Formatting Options in Button Slicer Visual
In the July 2025 Power BI update, the Shape formatting option was removed from the Button Slicer visual. This change has significantly impacted the ability to customize the appearance of slicers, esp...Simon_Howard15 hours agoNew MemberNew413Views0likes1CommentDisplay Delta table and column descriptions in Fabric Lakehouse Explorer/ Fabric on Browser
Microsoft Fabric Lakehouse should provide a visible and editable description field for Delta tables and columns in Lakehouse Explorer. Delta table metadata, such as comments or custom description pr...Darsh_16 hours agoNew MemberNew8Views1like0CommentsDate picker in slicer - Monday as as start of a week and one date pick
Hello! Since March 2022 date picker week starts from Sunday and there is no way to change it to Monday. It's highly inconvinient Would be more powerful, if there also were week numbers in regional...smazaev116 hours agoNew MemberNew318Views20likes3Comments