Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
Hope someone can help!
I'm trying to get the number of calendar days in a month for each employee, but the sum of the column doesn't seem to work:
Instead of the sum, it jut shows the number of days available for one employee, not all.
Can anyone help me with my measure? The measure I have created can be seen on the screenshot above.
Thank you in advance!
Solved! Go to Solution.
Please try
Calendar Days UK =
SUMX (
VALUES ( 'Table'[EmpName] ),
CALCULATE (
COUNT ( 'Calendar'[Date] ),
'Calendar'[Weekday/Wknd] = "Weekday",
CROSSFILTER ( 'Calendar'[Date], 'Table'[Date], BOTH )
)
)
Please try
Calendar Days UK =
SUMX (
VALUES ( 'Table'[EmpName] ),
CALCULATE (
COUNT ( 'Calendar'[Date] ),
'Calendar'[Weekday/Wknd] = "Weekday",
CROSSFILTER ( 'Calendar'[Date], 'Table'[Date], BOTH )
)
)
Hi,
I am not sure how your data model looks like, but please try the below whether it suits your requirement.
Calendar Days UK =
CALCULATE (
COUNT ( 'Calendar'[Date] ),
FILTER ( ALL ( 'Calendar' ), 'Calendar'[Weekday/Wknd] = "Weekday" )
)
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
120 | |
101 | |
71 | |
61 |