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 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...ryomaru08253 hours agoAdvocate INew26Views4likes1CommentConsistent Locale Handling Across Power BI, Fabric, PowerPoint, and Subscriptions
Microsoft Fabric and Power BI should provide consistent locale handling across all user experiences. Today, locales such as German (Switzerland) are correctly respected in Power BI Desktop and the Po...Le_M4 hours agoRegular VisitorNew19Views1like0CommentsIn Data Pipelines, Schedules should not be part of the definition
The request is to ensure Schedules are not included in the definition of a Data Pipeline for purposes of Deployment Pipelines. Today, when we deploy content across environments, the item frequent...schneiw5 hours agoAdvocate IVUnder Review813Views25likes3CommentsPipeline activity Refresh SQL Endpoint (preview) does not accept dynamic content
I am testing out the new Pipeline activity for Refresh SQL Endpoint, currently in preview. Sure, I get it that this is in preview, but it should at least have basic minimum functionality. It do...ToddChitt5 hours agoSuper UserNew590Views8likes6CommentsPower BI Admin & Governance Center – Centralized Activity and Usage Analytics
Subject: Feature Proposal: Advanced Power BI Admin & Governance Center – Centralized Activity, Access, Sharing, Licensing and Usage Analytics Dear Microsoft Power BI Team, I would like to propose a...Dr7awb10 hours agoNew MemberNew6Views0likes0Comments