Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
We have a pretty simple set of reports. We are using DirectQuery to a SQL 2016 Tabular model
We have a couple of simple measures defined in the Tab Model. the DAX for these looks like this
DAX in tabular model:
Tickets Logged:= CALCULATE(SUM('Ticket_vw'[Ticket Count]), USERELATIONSHIP(Ticket_vw[Date Call Logged],Date_Hierarchy_vw[Date]))
Tickets Resolved:= CALCULATE(SUM('Ticket_vw'[Ticket Count]), USERELATIONSHIP(Ticket_vw[Date Call Resolved],Date_Hierarchy_vw[Date]))
We link to this using DirectQuery to build a report that can be deployed. We deploy the report. Everything works fine.
We edit the PBIX or start a new PBIX and add a measure in Desktop (this is exactly what we expect users to do when they Edit in PowerBI Desktop.
DAX in PowerBI
Net Tickets = [Tickets Logged] - [Tickets Resolved]
Monkey about with this until you get a bad relationship issue
The Desktop edition shows the broken visual
Hi @Anonymous,
I'm not able to reproduce the issue. Which Power BI report server version did you run? Please try to run the latest version: https://www.microsoft.com/en-us/download/details.aspx?id=55790
Do you have any ideas? @mgmeyer @Jon-Heide
Best Regards,
Qiuyun Yu
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
13 | |
6 | |
4 | |
3 | |
2 |
User | Count |
---|---|
14 | |
10 | |
5 | |
3 | |
3 |