Meassure with Filter

[gill_thornton]

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:

No Students 2+ = CALCULATE(DISTINCTCOUNT(Exclusions[UPN]),

FILTER(

ALL(Exclusions),

Exclusions[Start date]>=MIN('Calendar'[Date])&&

Exclusions[Start date]<=MAX('Calendar'[Date])),

FILTER(ALLSELECTED(Exclusions),

CALCULATE(COUNTROWS(Exclusions))>=2))

Any help would be appreciated.

[gill_thornton]

Sample Data 

I would expect to see 4 students with 2+ suspensions in this sample file.

Thank you for your help with this.

[lbendlin · Accepted solution]

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.

[lbendlin]

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-...
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/1447...