Forum Discussion
Helper IMeassure with Filter
Hi
I work in a high school & am trying to create a measure that counts the number of students in a table with 2+ or 3+ exclusions. I have a calendar table, which contains terms & dates. I need to be able to add a slicer on my current visual which includes number of exclusions & number of students with exclusions. My table is a list of student identifier, type of exlcusion (permanent or suspension) start date and end date number of days excluded. I have tried using the following but it is just returning blanks:
You can do that in a graphical way (putting the UPN and any column count in a table or matrix)
or you can have a card visual with a measure behind it
Both solutions will be impacted by any date range filters you may want to apply.
4 Replies
- lbendlin
Super User
Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523 
gill_thorntonI would expect to see 4 students with 2+ suspensions in this sample file.
Thank you for your help with this.
- lbendlin
You can do that in a graphical way (putting the UPN and any column count in a table or matrix)
or you can have a card visual with a measure behind it
Both solutions will be impacted by any date range filters you may want to apply.
- gill_thornton
Thank you. This worked perfectly.