Calculate Date for Highest Percentage calculated

[Anonymous]

Dear,

I would like to retrieve the date on which the calculation of the success rate (percentage) is the highest.

Unfortunately, I cannot find the correct way of doing this. Below you can find a sample case. The idea is to retrieve 02/01/2021 as date in my example, as for this date the percentage is the highest(max). Can you please help me ?

Below the sample data, you can see the dax speudo code.

Thank you in advance

Tim

[AlB · Accepted solution]

Hi @Anonymous 

Place this measure in a card visual:

Measure =
TOPN (
    1,
    DISTINCT ( Table1[Date] ),
    DIVIDE (
        CALCULATE ( COUNT ( Table1[Status] ), Table1[Status] = "Success" ),
        CALCULATE ( COUNT ( Table1[Status] ) )
    ), DESC
)

Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers