Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Good day I have a measure ([# of Exits]: The number of Employees who have left the company in a sepcific period), defined as follows:
# of Exits = VAR Exits = CALCULATE ( COUNTROWS ( Employee ), FILTER ( Employee, Employee[EndDate] >= MIN ( 'Date'[Date] ) && Employee[EndDate] <= MAX ( 'Date'[Date] ) ) ) RETURN IF (ISBLANK(Exits),0,Exits)
The measure appears to work as expected, as per the filter context.
However, if I filter by the Month Name on the table, the bar chart no longer calculates as expected.
Is this the inteded behaviour?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.