Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code FABINSIDER for a $400 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
I created a DAX to count active employees count of the month and sum it with the count of new hiring requests from each departments to check what will me the total count if we hire new people.
For example i have 10 emplys in IT department and the rerquested to hire 2 more this month so it will show projected line of 12 for this month.
The problem im facing is when i select my slicedr to select all departments and sub departments, it shows actual and correct value.
but as soon as i select any department from slicer it doesnot give the correct value.
attatching below pics to explain my query.without slicer its greenline is showing 13
with slicer at HR its also giving 76+13 while correct is 76+2, making green line at 78
i tried creating many to many relationship btwn ERF lisyt and query 2 (Departments) but no result.
I'm not sure, but try changing this variable
VAR CurrentDate = MAX('Calendar'[Date])
to this
VAR CurrentDate CALCULATE(MAX('Calendar'[Date]), ALLSELECTED('Calendar'[Date]))
no its not working
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the February 2025 Power BI update to learn about new features.
User | Count |
---|---|
86 | |
78 | |
54 | |
39 | |
35 |
User | Count |
---|---|
102 | |
84 | |
48 | |
48 | |
48 |