Daily Rate Calculation

[Hakimi99999]

ID	Date	Day	IsGood
1	1/1/2018	Monday	TRUE
2	1/1/2018	Monday	TRUE
3	1/1/2018	Monday	TRUE
4	1/2/2018	Tuesday	TRUE
5	1/3/2018	Wednesday	TRUE
6	1/3/2018	Wednesday	TRUE
1	1/4/2018	Thursday	TRUE
2	1/5/2018	Friday	FALSE
3	1/5/2018	Friday	TRUE
9	1/5/2018	Friday	FALSE
10	1/6/2018	Saturday	TRUE
11	1/7/2018	Sunday	FALSE
12	1/7/2018	Sunday	TRUE
13	1/8/2018	Monday	FALSE
14	1/9/2018	Tuesday	TRUE

Hi I am looking for some help, if I want to calculate daily good rate( Daily True/ Dail True and False) , how do I create measure?

[MFelix · Accepted solution]

Hi @Hakimi99999,

Try this calcultated measure:

Daily good rate =
CALCULATE ( COUNTA ( DailyData[IsGood] ); DailyData[IsGood] = TRUE () )
    / CALCULATE ( COUNTA ( DailyData[IsGood] ); ALLSELECTED ( DailyData[IsGood] ) )

As you can see below it will give you the percentage on the selected date:

Regards,

MFelix