Forum Discussion

hashemalrifai's avatar
hashemalrifai
New Member
10 years ago
Solved

Apply filter on one column [Beginner]

Hi, I'm an absolute beginner, and I have to ask after so many attempts.  Let's assume that I have simple [Schools] and [Students] tables. Each student has a boolean flag column [IsActive]. And I'm ...
Need Help
  • matemusic's avatar
    matemusic
    10 years ago

    Hey, 

     

    maybe this?

     

    Total Active Students = CALCULATE(SUM(Students);Students[IsActive] = 1)

  • Anonymous's avatar
    Anonymous
    10 years ago

    hashemalrifai This should return only those students that are active.

    ActiveOnly = CALCULATE(SUM('Students'[IsActive]),FILTER('Students', 'Students'[IsActive]=1))

matemusic's avatar
matemusic
Advocate III
10 years ago

Hey, 

 

maybe this?

 

Total Active Students = CALCULATE(SUM(Students);Students[IsActive] = 1)