Forum Discussion

lukeSDM's avatar
lukeSDM
Helper V
6 years ago
Solved

wrong calculation and not showing in graph correctly

AllisonKennedy  maybe you will know the answer   I am trying to work out the attendance percentage for each student over time. Each Adno number (student) gets 2 attendance marks for each date for ...
Need Help
  • v-lili6-msft's avatar
    v-lili6-msft
    6 years ago

    hi  lukeSDM 

    Add a date table by this formula:

    Date = CALENDAR(MIN('Attendance overtime'[Mark date]),MAX('Attendance overtime'[Mark date]))

    Then create a relationship with [Mark date]

     

    and adjust the measure as below:

    /\ % = [count of /\] / COUNTA('Attendance overtime'[Mark]) *100 + 0

     

    Now use date field from date table in the x-axis in line visual.

     

    Result:

     

    here is sample pbix file, please try it.

     

    Regards,

    Lin

lukeSDM's avatar
lukeSDM
Helper V
6 years ago

Thank you this has resolved my issue!

v-lili6-msft's avatar
v-lili6-msft
Community Support
6 years ago

hi  lukeSDM 

It's pleasant that your problem has been solved, 😁 could you please mark the reply as Answered?

 

Regards,

Lin