Forum Discussion
COUNTIF with multiple criteria
Hi - I have a single data table with the following fields for the : ACCOUNT_NAME PRODUCT_NAME STATUS DATE_GENERATED And the measure I want to generate has the following logic: for the most...
Hi Anonymous
smth like
Measure =
CALCULATE(
COUNT(Table[ACCOUNT_NAME]),
FILTER(
ALL(Table),
(PRODUCT NAME = "Bus" && STATUS = "First") || (PRODUCT_NAME = "Car" && STATUS = "Second")
)
)Thanks - this workds perfectly - how would you incorporate 'for the latest month of data' into that though?