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

 

Thanks.

15 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    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's avatar
      MyPowerbi2020
      Icon for Helper IV rankHelper IV
      6 years ago

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

       

      Thanks.