Forum Discussion
SevsBo
Responsive Resident
Responsive ResidentTime intelligence not working but manual filtering does?
I have a simple Table1 connected to DateTable, where I am trying to calculate the count of Items in current month where ItemName from Table2 = Banana. If I create a Card and drag in Item, using C...
No solution found but flagging this as solution to close thread.
bhanu_gautam
Super User
Super UserSevsBo Try using
DAX
Approach1 =
CALCULATE(
COUNTA('Table1'[Item]),
DATESMTD(DatesTable[Date]),
FILTER('Table2', 'Table2'[ItemName] = "Banana")
)
DAX
Approach2 =
CALCULATE(
TOTALYTD(
COUNTA('Table1'[Item]),
DatesTable[Date]
),
FILTER('Table2', 'Table2'[ItemName] = "Banana")
)
SevsBoResponsive Resident
Responsive ResidentSadly neither of those work. It's interesting the first option seems to work if I add another measure for SAMEPERIODLASTYEAR, which returns a value but that value bears no relation to reality.
It's strange as I'm using the exact same fields as when I'm manually filtering it.