Forum Discussion

Hakimi99999's avatar
Hakimi99999
New Member
8 years ago
Solved

Daily Rate Calculation

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

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