DAX Help

# Child Absent 3+ Days = 
COUNTROWS(
    FILTER(
        VALUES( AttendanceMaster[ChildID] ),
        CALCULATE(
            COUNTROWS( AttendanceMaster ) >= 3,
            KEEPFILTERS( NOT AttendanceMaster[IsPresent] )
        )
    )
)

Best

D

Hi there.

I've had a look at the file. I think many of those measures are incorrect (and will not work correctly in many filtering conditions) but I might be wrong and from your point of view they are correct. Not sure but my experience tells me they are not right.

However, regardless of the above, I think you're after such a measure:

# Children 10%-20% = 
    COUNTROWS(
        FILTER(
            VALUES( AttendanceMaster[ChildID] ),
            .1 < [% of Absent Child]
            &&
            [% of Absent Child] <= .2
        )
    )

If this does not work, you have to create a measure (in place of [% of Absent Child]) that will calculate the percentage of time that a child was absent IN ANY SETTING. Please bear in mind that the measure should work correctly under any circumstances. If it's not, then the calculation is wrong as well.

Hope this helps.

Best

D