Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello
I have a file with employees data along with the StartDate and the FinishDate of each emloyee.
Now the requirement is to count rows where the StartDate is BEFORE min date of the slicer AND the FinishDate is AFTER the max date of the slicer!!!
The slicer contains Date column from the date table wich is related to the fact table using StartDate, and also to EndDate (inactive relationship).
I created a measure but it always returns Blank:
I believe the blank value is because the measure looks for the values outside the selected date range...
Thanks!
Solved! Go to Solution.
Hi @Sab
You need to use Filter in your calculate, try something like this:
Calculate([All rows], Filter(all(People Overview),People Overview[Start Date]<StartDate && People Overview[Finish Date]>EndDate))
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Hi @Sab
You need to use Filter in your calculate, try something like this:
Calculate([All rows], Filter(all(People Overview),People Overview[Start Date]<StartDate && People Overview[Finish Date]>EndDate))
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
61 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |