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
Support Cross-Tenant (B2B/MTO Member) Authentication for Fabric Data Warehouse in Power BI Desktop
Microsoft Fabric Data Warehouse SQL Endpoints currently do not support cross-tenant authentication scenarios when accessed from Power BI Desktop. While B2B/Multi-Tenant Organization (MTO) member u...v-nandagm46 minutes agoMicrosoft EmployeeNew2Views0likes0CommentsPower BI Report Builder - Difficult to Use and Ugly.
So I've definitely been spoiled in the modern age. So many apps that are integrated well with top-notch UI, and intuitive processes. Power BI Report Builder is surprisingly lacking in this. While I a...rs_rae9 hours agoAdvocate INew14Views0likes0CommentsIndividual L/R column borders for Matrix
Add Power BI feature for applying left and/or right borders to individual matrix columns, with customizable border thickness and color. This would let users visually group related measures, highlight...AaronReasoner13 hours agoNew MemberNew5Views0likes0CommentsSupport Git-Integrated Files in Fabric Workspaces
Overview Allow users to store and manage arbitrary files such as .md, .sql, .py, and .yml directly in a Fabric workspace, with built-in Git integration. Value This would keep documentation, SQL sc...ryomaru082517 hours agoAdvocate INew44Views4likes1Comment