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 ,
You may create measure like DAX below.
Count ACCOUNT_NAME =
CALCULATE(COUNT(Table[ACCOUNT_NAME]),FILTER(ALLSELECTED(Table),YEAR([DATE_GENERATED])=YEAR(TODAY())&&MONTH([DATE_GENERATED])=MONTH(TODAY())&&(PRODUCT NAME = "Bus" && STATUS = "First") || (PRODUCT_NAME = "Car" && STATUS = "Second")))
Best Regards,
Amy
Community Support Team _ Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quic