Forum Discussion

Mischa's avatar
Mischa
Frequent Visitor
5 years ago
Solved

DAX - VAR_Count_Filters Assistance

Hello!   Can I please request some masterminds to assist in the following problem?   I have recreated a table to illustrate the problem.    Purchased date Apple Type Price ANSWER ...
  • amitchandak's avatar
    amitchandak
    5 years ago

    Mischa , Try new column like


    ANSWER =
    VAR _date = eomonth([Purchased date],-24)

    if(APPLE[PRICE] = "expensive", countx(filter(APPLE, APPLE[Type] =earlier(APPLE[Type]) && search("Golden",APPLE[Type],,0) =0 && [Purchased date] <= earlier([Purchased date]) && [Purchased date] >=_date),[Purchased date])

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

Mischa , Try new column like


ANSWER =
VAR _date = eomonth([Purchased date],-24)

if(APPLE[PRICE] = "expensive", countx(filter(APPLE, APPLE[Type] =earlier(APPLE[Type]) && search("Golden",APPLE[Type],,0) =0 && [Purchased date] <= earlier([Purchased date]) && [Purchased date] >=_date),[Purchased date])

Mischa's avatar
Mischa
Frequent Visitor
5 years ago

Thank you kindly sir!