Forum Discussion

Hakimi99999's avatar
Hakimi99999
New Member
8 years ago
Solved

Daily Rate Calculation

IDDateDayIsGood
11/1/2018MondayTRUE
21/1/2018MondayTRUE
31/1/2018MondayTRUE
41/2/2018TuesdayTRUE
51/3/2018WednesdayTRUE
61/3/2018WednesdayTRUE
11/4/2018ThursdayTRUE
21/5/2018FridayFALSE
31/5/2018FridayTRUE
91/5/2018FridayFALSE
101/6/2018SaturdayTRUE
111/7/2018SundayFALSE
121/7/2018SundayTRUE
131/8/2018MondayFALSE
141/9/2018TuesdayTRUE

 

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's avatar
    MFelix
    8 years ago

    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

1 Reply

  • MFelix's avatar
    MFelix
    Super User
    8 years ago

    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