Forum Discussion

Hakimi99999's avatar
Hakimi99999
New Member
8 years ago
Solved

daily rate calculation

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

 

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

  • Phil_Seamark's avatar
    Phil_Seamark
    8 years ago

    HI Hakimi9999

     

    Please try this

     

    Measure = 
    DIVIDE(
        CALCULATE(COUNTROWS('Table1'),'Table1'[IsGood] = TRUE),
        COUNTROWS('Table1')
        )

4 Replies

  • Phil_Seamark's avatar
    Phil_Seamark
    Icon for Microsoft Employee rankMicrosoft Employee
    8 years ago

    Can you please let us know how you would like to calculate the daily rate?

     

    Is it the total number of TRUE records per day divided by the total number of ALL records for the day?

      • Phil_Seamark's avatar
        Phil_Seamark
        Icon for Microsoft Employee rankMicrosoft Employee
        8 years ago

        HI Hakimi9999

         

        Please try this

         

        Measure = 
    DIVIDE(
        CALCULATE(COUNTROWS('Table1'),'Table1'[IsGood] = TRUE),
        COUNTROWS('Table1')
        )