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 QR codes in the barcode scanner in the Power BI app
I was surprised to find that the barcode scanner inside of a Power BI report in the mobile app only supports scanning barcodes, not QR codes. Our warehouse uses QR codes everywhere, so I cannot use t...Jaap_O_RFH6 hours agoNew MemberNew15Views0likes0CommentsAllow enabling Lakehouse Schemas on an existing Lakehouse
Right now Lakehouse Schemas can only be turned on when you first create a Lakehouse. If you already have one running in production and later decide you need schemas, there is no way to enabled them o...AlessioAndriulo6 hours agoAdvocate INew14Views0likes0CommentsAllow enabling Lakehouse Schemas on an existing Lakehouse, without recreating it
Today, Lakehouse Schemas can only be turned on when a Lakehouse is first created. There is no supported way to enable schema support on a Lakehouse that already exists — the only workaround is creati...AlessioAndriulo7 hours agoAdvocate INew33Views4likes0CommentsWorkspace Folder & Subfolder Inventory View for Power BI Reports and Apps
Problem: Many organisations use Power BI workspace folders and nested subfolders to organise reports by department, business area, project, or function. While this structure helps keep content organ...rijesh7 hours agoFrequent VisitorNew15Views1like0Comments