Forum Discussion

MyPowerbi2020's avatar
MyPowerbi2020
Icon for Helper IV rankHelper IV
6 years ago

Need help with Dax

  Dear Experts,   I have the data like the above , user has a date slicer . The requirement is if user selects a date or dates that should give the below table : Email , MAX value of clicke...
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi MyPowerbi2020 

check this it will show only for email.

Measure = CALCULATE(MAX(Table[Clicked]),ALLEXCEPT('Table','Table'[EMAIL]))

MyPowerbi2020's avatar
MyPowerbi2020
Icon for Helper IV rankHelper IV
6 years ago

Anonymous ,

no this is not working.

 

 

Thanks,

  • SubodhTiwari's avatar
    SubodhTiwari
    Frequent Visitor
    6 years ago

    How about simply this?

    MaxClicked = MAX(Data[Clicked])
  • v-easonf-msft's avatar
    v-easonf-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi , MyPowerbi2020 

    Try measure as below:

    result = 
VAR t =
    ALLSELECTED ( Data )
VAR tab =
    SUMMARIZE (
        t,
        Data[Email],
        "Result", CALCULATE (
            MAX ( Data[Clicked] ),
            FILTER ( t, Data[Email] = EARLIER ( Data[Email] ) )
        )
    )
RETURN
    IF (
        ISFILTERED ( Dates[Date] ),
        IF (
            SELECTEDVALUE ( Data[Clicked] )
                = SUMX ( FILTER ( tab, [Email] = SELECTEDVALUE ( Data[Email] ) ), [Result] ),
            1,
            0
        ),
        1
    )

    Then apply it to visual filter pane.

     

     

    Please refer to the attached file for more details.

     

    Best Regards,
    Community Support Team _ Eason
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • v-easonf-msft's avatar
    v-easonf-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi , MyPowerbi2020 

    If you just  need show the max clicked,just try measure as below:

    Max clicked = 
VAR t =
    ALLSELECTED ( Data )
VAR tab =
    SUMMARIZE (
        t,
        Data[Email],
        "Result", CALCULATE (
            MAX ( Data[Clicked] ),
            FILTER ( t, Data[Email] = EARLIER ( Data[Email] ) )
        )
    )
RETURN
   SUMX ( FILTER ( tab, [Email] = SELECTEDVALUE ( Data[Email] ) ), [Result] )

     

    Best Regards,
    Community Support Team _ Eason
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.