Summarize

---

karkar wrote:

Helo smoupre,

 

I tried to do the denominator and all the rows gettign a value of 6

 

For Jenny denom should be 4 since there is 4 records

For Penny denom should be 1 since there is a single record

For Manny denom should be 1 since there is a single record

 

For Jenny neum should be 2 since there is 2 records for Jenny which had a value for Days_to_come_back

For Penny and Manny, Neum should be 0 since they both dont have a value under Days_to_come_back

 

Generally the value under Days_to_come_back if exists has a value from 1-30

 

---

karkar

You can try to create 3 measures as below

denom =
CALCULATE (
    COUNTROWS ( 'Summarize' ),
    ALLEXCEPT ( 'Summarize', 'Summarize'[ID], 'Summarize'[Name] )
)

neum =
IF (
    ISBLANK (
        COUNTROWS ( FILTER ( 'Summarize', 'Summarize'[Days_to _come_back] > 0 ) )
    ),
    0,
    COUNTROWS ( FILTER ( 'Summarize', 'Summarize'[Days_to _come_back] > 0 ) )
)
rate = [neum1]/[denom]