Forum Discussion

NilR's avatar
NilR
Icon for Post Patron rankPost Patron
4 years ago
Solved

DAX Max Function with multiple conditions

Question to answer: If John in zip code group 0 between 202001 and 202004 has ever voted?   This is how I would right in sql but i need a measure in DAX to use the Y or N result in another me...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    HI NilR,

    You can try to use follow measure formula to get the count of vote rows based on the current 'zip' and 'member' group of a specific year range:

    measure =
VAR voteCount =
    CALCULATE (
        COUNTROWS ( Table ),
        FILTER (
            ALLSELECTED ( Table ),
            [Vote] = "Y"
                && AND ( [INC Year] >= 202001, [INC Year] <= 202004 )
        ),
        VALUES ( Table[Zip_Code] ),
        VALUE ( Table[Member] )
    )
RETURN
    IF ( voteCount > 0, "Y", "N" )

    Regards,

    Xiaoxin Sheng

NilR's avatar
NilR
Icon for Post Patron rankPost Patron
4 years ago

Thank you! I need the Y and No result for another measure to use. this doesn't work for me.

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

NilR , Not very clear

 

but this will give Y

if(not(isblank( Calculate(count(Table[Memeber]), filter(allselected(Table), Table[VOTE] ="Y" && Table[MEMBER] = max(Table[MEMBER]))) )) , "Y", Blank())

  • NilR's avatar
    NilR
    Icon for Post Patron rankPost Patron
    4 years ago

    Thank you! I just updated my question with what I have tried and is not working .