Forum Discussion

Mischa's avatar
Mischa
Frequent Visitor
5 years ago
Solved

DAX - VAR_Count_Filter Ex2

Hello again,    An extention on my previous request,    Could I please request assistance with this problem:   Purchased date Apple Type Price Rating ANSWER 2021/07/08 G...
  • Jihwan_Kim's avatar
    5 years ago

     

    ANSWER CC =
    VAR _currenttype = Data[Apple Type]
    VAR _filtertable =
    FILTER ( Data, Data[Apple Type] = _currenttype && Data[Rating] <> BLANK () )
    VAR _mostrecent =
    MAXX ( _filtertable, Data[Purchased date] )
    VAR _rating =
    MAXX (
    FILTER (
    Data,
    Data[Apple Type] = _currenttype
    && Data[Rating] <> BLANK ()
    && Data[Purchased date] = _mostrecent
    ),
    Data[Rating]
    )
    RETURN
    IF (
    Data[Purchased date] = _mostrecent
    && Data[Rating] = _rating,
    Data[Rating]
    )

     

     

    https://www.dropbox.com/s/8culxo9z5iiyn4y/mischa.pbix?dl=0