User Profile
DRJ1994
Helper I
Joined 4 years ago
User Widgets
Contributions
Division issue and circular dependancy error
Hi all, I have run into a series of errors on a dashboard I am trying to produce. I am trying to work out the occupancy rate of a small block of flats. I have the below visual: The sum of daysinservice is how many days combined customers have spent in the accomodation in dates ranging from 2018 to 2023. The possible bed days is how many possible days the rooms could be occupied in the same date range. The date range is 25/01/2018 to today, there are 2149 days in that range, there are 6 rooms in the accomodation so to achieve this number I have done Daysinrange *6 The first issue I have, is when trying to divide daysinservice (DIS) by Possible Bed Days (PBD) I initially recieved the correct answer of 66%. However, when I moved the date slider around, to change the period that I was looking at, the values for DIS became 5000 for example, and the values for PBD became 9000, however the division was returning an answer of 128% - So I am not sure why it is going wrong. The second issue, I have since removed the measure for the division, and when I am trying to add a new measure or column, I am getting the below error: I have also attached an image of the work in progress dashboard as this may help with understanding what I am talking about. Any tips or advice would be greatly appreciated. Many thanks, DRJHelp with conditional formatting
Hi all, I am trying to set up conditional formatting on a table of mine, please see screenshot below: The table shows a target date, and a column which shows the amount of days between today and the target date. I am trying to get the conditional formatting to behave as follows: less than 100 days = red 101-365 = blue 366 + = green As you can see from the screenshot I have the rules set up to reflect this, but when I click ok on the formatting box, nothing is changing (the majority should change to blue, and one should change to green, but instead everything is just staying as is) Any tips or help would be greatly appreciated. Thanks, DRJValues only being counted once when they should be counted more than once
Hello all, I am in the process of building a dashboard where we are monitoring audits for services that we manage. There are 64 services that are expected to be audited twice annually, so a target of 128 audits in total. I have a service table plugged into the dashboard and have a simple measure of "Count of Services X 2" to give me the target audit figure - this is all fine. The issue I have, is when a second audit is being completed and I am filtering by service is that the cards in my visual are not updating, please see screenshot below for details: The target audit is correct, as this is for the individual service that I have filtered at the top. The complete audits and audits complete % cards however should be 2 and 100%, but they are not updating. These measures are measured by: "DISTINCTCOUNT(ReportName[ServiceName]) +0" "DIVIDE[COMPLETE AUDITS], ]TARGET AUDIT]) I believe the issue has stemmed from the use of a distinct count, but I think this is necessary. The way the data is laid out in the source spreadsheet is a column for the service name, and then around 500 yes/no columns for questions as part of the survey/audit. I have had to unpivot this in Power BI, but this has now resulted in ~500 entries per individual service, so when I take the distinct count off and just do it as a count, then its telling me there are 500 completed audits which is obviously not true. As shown in the screenshot above, it is recognisning that an audit has been completed twice in the little table that contains the questions - so I am unsure how to fix the card measures to reflect this as well. Any tips or advice would be greatly appreciated, I have been stuck on this for a few hours and have run out of ideas. Thanks, DRJHelp with Delimiting
Hi guys, Hopefully someone can help with my query, although I am not sure if what I am trying to do is possible or not. I have a table with the column pictured below. I am trying to delimit by ";" (The / is fine and I do not need to delimit by this). So if we take the top row for example it should be split into rows as follows: Attendance allowance / state pension / pension credit Benefits advice Physical health Visit Well being The issue I am having is PBI is counting these now as 5 seperate entries rather than 1. For example the source data there are only 4600 entries, but when I delimit in PBI and performing a count there are over 12000 entries. So I think the issue is that it is counting each row as it's own entry, I understand why this is happening but I am just trying to see if there is a way to bring it closer to the 4600 that is on the source data. Is there a way to fix this? I have tried a few different things but have had no joy. Thanks in advance. DRJ.Help with %s in visual
Hi all, Hope somebody can help with my query. I have the below visual. The black bar shows how many cases are currently open, the red bar shows how many cases are overdue, and the percentage is % of open cases that are currently overdue. However, the % is not changing and is always staying as the same figure. Please see below visual attached: The week of 15th Jan, the % should be 100, but instead is showing as the 76.19 which is the current and correct % for this weeks report. What should be happening is the line should be different based on each week at the bottom, but for some reason the number is staying the same for each week. Any ideas or advice would be greatly appreciated. Many thanks DRJ
