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 @stpnet,
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
Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.
Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!
User | Count |
---|---|
7 | |
2 | |
2 | |
2 | |
1 |
User | Count |
---|---|
26 | |
11 | |
6 | |
4 | |
4 |