Need help with Dax

[MyPowerbi2020]

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 clicked.

Thanks.

[pranit828]

HI @MyPowerbi2020 

I would use the below

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

The above will give the max number of clicks for every row based on email and date.

[MyPowerbi2020]

Hi Pranit, Thanks for the reply , but the measure is always returning 1 , irrespective of dates.

Thanks.

[pranit828]

HI @MyPowerbi2020

Can also screenshot your output.

[MyPowerbi2020]

Thanks.

[pranit828]

Hi @MyPowerbi2020 

Please also paste the expected output if the below measure doesn't work. The sample input is in the ask.

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

[MyPowerbi2020]

Hi @pranit828 ,

I think this is not working.

Thanks.

[pranit828]

HI @MyPowerbi2020 

Its because the the CampaignName was misspelled in the privous reply.

use below

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

[MyPowerbi2020]

Hi @pranit828 

In my end I have typed that correctly , not sure its not working.

Thanks.

[pranit828]

HI @MyPowerbi2020 

Can you paste what you are expeting as the output for the input you have pasted in the original ask.

[MyPowerbi2020]

Hi @pranit828 

basically based on the selected dates I need to show the MAX(Clicked) for any EMAIL.

Thanks.

[pranit828]

Hi @MyPowerbi2020 

check this it will show only for email.

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

[MyPowerbi2020]

@pranit828 ,

no this is not working.

Thanks,

[v-easonf-msft]

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.

[v-easonf-msft]

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.

[SubodhTiwari]

How about simply this?

MaxClicked = MAX(Data[Clicked])