Count distinct and then find max of the distinct count

[Anonymous]

Dear All,

I would like to count distinct emails for each day and then find the max of the distinctcount of each day.

How can I do that ? Below is an example.

Thank you.

SAMPLE TABLE:

DISTINCT COUNT EMAILS 

FINAL TABLE MAX OF DISTINCT COUNT

[Fowmy · Accepted solution]

@Anonymous 

Create the following measure and use with the date:

Max Count of Emails = 
MAXX(
    ADDCOLUMNS(
        VALUES(Table12[Email]),
        "mx", CALCULATE( COUNT(Table12[Email] ))
    ),
    [mx]
)

[Fowmy · Accepted solution]

@Anonymous 

I am getting the same results you showed. insert a table visual and add date and the measure.

[Fowmy · Accepted solution]

@Anonymous 

I am getting the same results you showed. insert a table visual and add date and the measure.

[Fowmy · Accepted solution]

@Anonymous 

Create the following measure and use with the date:

Max Count of Emails = 
MAXX(
    ADDCOLUMNS(
        VALUES(Table12[Email]),
        "mx", CALCULATE( COUNT(Table12[Email] ))
    ),
    [mx]
)

[Anonymous · Accepted solution]

Actually I forgot to tell I have date slicer whenever I slice the date it should return one number and it should be 4 in this case I am sorry thank you 

[Anonymous]

It is counting the rows I need max of count . Can you fix that please? Thank you.