STEVEMILLS04
Board Regular
- Joined
- Oct 8, 2009
- Messages
- 113
I have a date table that is standard. In my data table I have a list of 'ClosedDates' that does include blanks (maybe this is the issue?). When I filter this table manually I get the results I expect, a count of 380 rows. However, my measure is only calculating 363 rows. I went through the data and cannot determine any root cause of why this is happening (such as a specific date with 17 rows). The funny thing is, the 'ClosedDates' has 10 blank rows, 7 have a start date in 2019 but no closeddate. The sum is 17 but can this really be related? I figured its unlikely but honestly have no clue what is happening.
My slicer is a timeline with the month selection. So I select February and want totals for 2019 through end of February. I have the same formula but counting the start date column and it works perfectly. (It is a IT ticket report that calculates the number of tickets opened and closed in a period)
My measure:
My slicer is a timeline with the month selection. So I select February and want totals for 2019 through end of February. I have the same formula but counting the start date column and it works perfectly. (It is a IT ticket report that calculates the number of tickets opened and closed in a period)
My measure:
Code:
TOTALYTD(COUNTA(Query1[CloseDateRelate]),CalendarTable[Date])
Last edited: