Forum Discussion
Solved
Total of Measure
I'm struggling to find a method for Power BI to tell me how many (the total) records it has found that meet a filter condition: "Present" is a percentage measure determined from the counts of presen...
Hi,
I did have no insights in your data so I assumed that student[present] is a boolean (true/ false)
What I have done is:Created a measure for % present in the classes.
Present % =
DIVIDE(
CALCULATE(SUM(Students[Present])),
CALCULATE(COUNTROWS(Students))
)Created a measure where it counts the rows when the attendance is perfect (100%)
Total 100% Attendance Records =
CALCULATE(
COUNTROWS(
FILTER(
VALUES(Students[Name]),
[Present %] = 1
)
)
)Let me know if it helps!
Natalie_iTalent
Administrator
AdministratorDear community members,
A response that was unrelated to the original topic has been removed from this thread. We wanted to add this clarification as there are additional comments related to that comment shown.
Please feel free to reach out to me if you have any questions.
Best,
Natalie H.
Community Manager