Employee Retention, Filtering Based on Job Title and Business Location
Hi everyone, Thanks to this group I managed to work on my dax to calculate retention % for the business. However, the problem that I'm experiencing is when I tried to filter my visualization based on Job Title or Business Unit code, my measure doesn't change in line with the filter. My aim is to see retention % based on different business units and job title's so we can identify possible challenges for retaining talent within the organization. Here is my DAX: Thank you so much for the support! Retention % = VAR _Previous12START = EOMONTH ( MAX ( 'Calendar'[Date] ), -13 ) + 1 VAR _Previous12END = EOMONTH ( MAX ( 'Calendar'[Date] ), -1 ) VAR _LEFT = CALCULATE ( COUNT ( 'Master Data'[Employee Code] ), FILTER ( ALL ( 'Master Data' ), 'Master Data'[Date Engaged] >= _Previous12START && 'Master Data'[Date Engaged] <= _Previous12END && 'Master Data'[Date of Resignation] >= _Previous12START && 'Master Data'[Date of Resignation] <= _Previous12END ) ) + 0 VAR _Total = CALCULATE ( COUNT ( 'Master Data'[Employee Code] ), FILTER ( ALL ( 'Master Data' ), 'Master Data'[Date Engaged] <= _Previous12END && OR ( 'Master Data'[Date of Resignation] >= _Previous12START, 'Master Data'[Date of Resignation] = BLANK () ) ) ) RETURN 1 - DIVIDE ( _LEFT, _Total ) This is how the visualization look like:
Editing and overwriting a Power BI file on the Report Server - Query Filters changes not being read
I have been running into a consistent problem. I'll download one of my reports from the Power BI Report server intalled on our network, go into the query editor to modify a query, apply the changes, the data will change in the visuals and the tables on the desktop version and then when I overwrite the file on the server, it will display the data as though the filter did not change. It behaves like it only records the filters upon the initial publish and then ignores all changes after that. This does not happen when I make other types of query changes, just specifically a filter change to the actual queries. The work around is to delete the file and upload it fresh but then I lose all my credentials, user groups and scheduled refreshes. Is this a known bug or is there a configuration change my administrator should make?
