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
achinm45's avatar
achinm45
Icon for Advocate IV rankAdvocate IV
10 years ago

Select your visualization.

Go to Fields section (icon with 3 columns , next to paintbrush)

There from Values fields, remove the column

  • hashemalrifai's avatar
    hashemalrifai
    New Member
    10 years ago

    Thanks, achinm45 for answering, but I really need to have two columns, one for all students, and the other for [active] students. 

    In other words, I need two chart columns: 

    The first: All students

    The seconds: All students WHERE IsActive = True

     

    Thanks, and I hope that I explained better :) 

    • Anonymous's avatar
      Anonymous
      Not applicable
      10 years ago

      hashemalrifai This should return only those students that are active.

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