Forum Discussion

lukeSDM's avatar
lukeSDM
Helper V
5 years ago
Solved

Measure not counting properly

I have 3 measures:   The first one calculates a students attendance(This one works fine it counts specfic marks which are date stamped and divides by total) - Calculated attendance = ([ALL Presen...
Need Help
  • Icey's avatar
    Icey
    5 years ago

    Hi lukeSDM ,

     

     

    The third is meant to count those who have a Y from the previous measure -
    <96 = (COUNTROWS(FILTER('Pupil_Data','AttendanceOvertime'[pa y/n]="Y"))).
     

    Try to count 'AttendanceOvertime' table, not 'Pupil_Data' table like these:

    <96 =
COUNTROWS ( FILTER ( 'AttendanceOvertime', [pa y/n] = "Y" ) )

    <96 =
CALCULATE (
    DISTINCTCOUNT ( 'AttendanceOvertime'[Student] ),
    FILTER ( 'AttendanceOvertime', [pa y/n] = "Y" )
)

     

     

     

    Best Regards,

    Icey

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

amitchandak's avatar
amitchandak
Super User
5 years ago

lukeSDM , what you are using on axis ? That is your group by

 

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

 

lukeSDM's avatar
lukeSDM
Helper V
5 years ago

My attendance table has a relationship with a date table so I can timestamp students attendance during specific weeks.