Creating Separate Reports for each Group
Hello, I'm trying to create separate reports for each group (High School District). Specifically, each school district needs its own title "Quarterly Report", Payee & Payer Address, and the data table by school district. The closest I've gotten is to insert page breaks in the data table at the bottom of the report between each school district -- so in other words, I get one heading followed by page-broken tables by school district. Can someone point me in the right direction? Thank you!
Overall Figure/Table/Graph by summary of Measure in DAX
Hi I've been struggling with this for a while, and no amount of googling has got me any closer. I have a dashboard which monitor people carrying out tasks on an app. If they get to the end, they are classed as 'Fully Compliant'. I have a table on my dash that illustrates this at a user level, which works fine. (see below mocked up in dummy data), but regardless of how I've tried to do it, I can't get an overall figure. From the above the: User is a field in the table Orders counts the number of rows in the table for each user Fully Compliant = IF([App Used in Full] <> [Orders],"N","Y") [App used in full] counts completed rows in same table The issue that I have is that the company want to have a summary of how many users are compliant, and have visual as numbers, graphs etc. See below mock up in Excel. There are numerous date/category filters on the dashboard from that table, which still need to work for the 'Fully Compliant' field, which is why (unless you guys know a way) I can't use Power Query. I'll obviously need to tie in the User to the formula, but I can't seem to group by the Y/N measure to do Countif etc. I've tried creating a table based on SUMMARIZECOLUMNS which also did not work. Any and all help is much appreciated. Thanks Shani
Manage grouping (Internal error: An expression services limit has been reached...)
Hi, I have a report which has multiple direct queries coming from SQL views into Power BI Desktop (RS Server version). I am using the latest version (May 2020 with June 30th patches) One of the my direct query SQL views helps populate 2 visuals. There are about 6300 rows of data coming from the data source right now, and it runs very quick in SQL. The 1st visual (a KPI card) simply provides a count and works fine. The 2nd visual (a bar chart with 3 drill-downs, 4 fields) does not load and gives the error "Internal error: An expression services limit has been reached. Please look for potentially complex expressions in your query, and try to simplify them.. The exception was raised by the IDbCommand interface." After playing around, I noticed two things: 1. If i reduce the thr drill-down to 2 levels (3 fields), the 2nd visual (bar chart) works 2. Instead of running "Select <column names> from View" if i change the query to "Select top 7000 <column names> from View" the 2nd visual start working (note there are only 6300 rows of data in my testing, so output for both is same) This seems to be a Power BI aggregation/grouping issue in the bar chart (which has multiple drill-downs so has multiple levels of aggregation). Is there a setting which I could change? Or what esle can be done to manage this (especially if the number of rows increase in the future)? Would this have to be handled similarily in Power BI Report Server?
