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 , I am not able see the group by/un summarized column of visual.

 

based on that try

COUNTROWS(FILTER(values('Pupil_Data','AttendanceOvertime'[Group by visual]) , [pa y/n]="Y"))

 

replace [Group by visual] with correct column

lukeSDM's avatar
lukeSDM
Helper V
5 years ago

amitchandak 

 

There is no columns they are all measures.

 

You can see the total in the table of the <96 measure is 5 which is incorrect as in the p/a y/n measure in the table shows more than 5 Y's.

 

This is how it looks in graph from and all weeks are wrong.

 

Many thanks,

 

 

  • 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

      amitchandak 

       

      My 'X' Axis is the academic week number.

       

      My 'Y' Axis is the count of Y.

       

       

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