Measure filtering within Graphs not functioning as expected
Hi, I have an issue where a measure is being used in a horizontal bar graph; along the Y axis is split out by Department and along the X axis is the measure value for the different departments. The measure when split on the graph seems to be not filtering by each department throughout the whole graph. The Issue seems to be the graph. For each bar, its not calculating the measure correctly. The bars of the bar graph (see picture below) total the annualised sick ratio (same measure that is used in the graph, see picture at the bottom). Why is this happening? Shouldn't the bars being calculating their own sickness ratio based on the annual sickness ratio measurement below? From how it's interacting, it looks like the filtering occurring to split up the measure into the bars looks like it's filtering the measure [Past 12 Month Sick Days] but not the [Active Employees] and [Headcount (12 Months Prior)] measures. However, when I use a filter on the page for those departments, it does in fact filter the whole measure, and not produce the issue described above. In Summary I would like my bars in my bar graph to be calculating their own annual sickness ratio, and I'm unsure if it's because of the relationships put together, or if graphs can't do something that complicated. The measure(s) is calculated as below: Annualised Sickness Ratio = ([Past 12 Month Sick Days]/((([Active Employees]+[Headcount (12 Months Prior)])*252)/2)) Where Both [Active Employees] and [Headcount (12 Months Prior] are measures inside a table called Employee Listing and [Past 12 Month Sick Days] = VAR SelectedDate=LASTDATE('Date Dimension'[Date]) VAR SelectedDate12MonthsPrior=SAMEPERIODLASTYEAR(SelectedDate)+1 RETURN CALCULATE(SUM(Absences[In Year Adjusted Total Sick Workdays]), DATESBETWEEN('Date Dimension'[Date],SelectedDate12MonthsPrior,SelectedDate), Absences[STS/LTS?]="STS") Where In Year Adjusted Total Sick Workdays is a measured column part of the absences table, see relationship map below. NB: I can't share raw data as it's sensitive information. Thanks for your help in advance.
Date Value that Refers to all Previous Dates in Chart
Hello, hoping someone can help. I am looking to create a function that allows the month value displayed on a table to actually refer to all data on or before the month displayed. This is in order to simulate point in time compliance figures. For example, May 2021 would actually show all data from the end of May 2021 backwards. January 2021 would similarly show from the end of January 2021 backwards. Hope this helps explain my issues 🙂 ThanksStacked Column Chart Help with % Count
Hi, I have a measure that gives the percentage of on time deliveries we make for each customer with the following formula (Difot Monthly % = divide(sum(Difot[Difot Pass Count]),sum(Difot[Difot Count])) eg Im trying to think of a formula to give the count of how many customers would fall into each braket such as difot <50%, 50 - 60%, 70-80%, etc up to 100% so I can create a stacked column chart and show by month. The Above is a manual upload that wont change with the new month I have tried the following <50% = COUNTROWS(filter(Difot,DIVIDE(sum(Difot[Difot Pass Count]),sum(Difot[Difot Count]))<=50)) but it returns the number of rows. But i realise I want to count how many customers fall into each bracket which I haven't been able to include. Any ideas? Thanks in advance, EamG
