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,
Recently I got help from some great community members with a measure that shows all data points inside of a selected date range (but not using a start or end date in the filter visual). That was successful but I'd like to take it one step further. I would like to be able to count the items that show up within a specified range (whether that be by year, quarter, month, or day). For example, I have selected Q3 in my filter and this is returned in my Gantt chart:
As we can see, there are 5 items that "exist" in Q3 (even though part of the tasks exist outside of the date range) so I would like to have a matrix that could show that number. Here is the code that was used in my previous post:
This formula was used on the gantt in this way:
I then use a date field from a date table in my filter to select the desired dates.
That all being said, how do I write a measure to be able to count the items? Any assistance would be greatly appreciated!
Solved! Go to Solution.
@JLambs20 , Try new measure like
countx(Filter('SD Time Off', 'SD Time Off'[Time Off Start Date] <= MAX ( 'All Dates'[fulldate] ) && (
ISBLANK ( 'SD Time Off'[Time Off End Date] )
|| 'SD Time Off'[Time Off End Date] >= MIN ( 'All Dates'[fulldate] ))
), 'SD Time Off'[Time Off Start Date])
@JLambs20 , Try new measure like
countx(Filter('SD Time Off', 'SD Time Off'[Time Off Start Date] <= MAX ( 'All Dates'[fulldate] ) && (
ISBLANK ( 'SD Time Off'[Time Off End Date] )
|| 'SD Time Off'[Time Off End Date] >= MIN ( 'All Dates'[fulldate] ))
), 'SD Time Off'[Time Off Start Date])
Amazing! Thank you so much! This is going to help out a ton!
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 |
---|---|
111 | |
95 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |