Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Pick Department on the Bases of Student Selection From dropdown and Sum over All fee submitted

Hello Community,
I have a scenario that to Pick Department on the Bases of Student Selection From dropdown and Sum over All fee submitted for that department.

1: I have a student dropdown. (User can select 1 or more then 1 at a same time)
2: I need to pick the Department of the selected Student/Students (For Example IT, Commerace, Law etc)
3: I have to calculate the total Fee submitted for thta department. (will not consider the student but the department of that student)

I need something like this

Fee Submitted = 

VAR SelectedStudent =

VAR AssociatedDEPT =
        'Student'[Name] IN SelectedStudent
        'Student'[Department] IN AssociatedDEPT

Your quick response will he highly appriciated
Super User
Super User

This shall also provide the same result

Fee Submitted =
    SUM ( 'Student'[FeeSubmitted] ),
    ALL ( 'Student'[Name] ),
    VALUES ( 'Student'[Department] )
Super User
Super User

Hi @Rana_Rumeel 
Please try

Fee Submitted =
    VALUES ( 'Student'[Department] ),
        SUM ( 'Student'[FeeSubmitted] ),
        ALL ( 'Student'[Name] )

For Example there is a student and not submitted the fee, If I am selecting such student the table gets empty.

because I only need his Department and against that department need to sum all the fee. and need to ignore Student filter.

I hope you have tried the code. What results have you obtained? How does your visual look like?

I tried the code you provided but when I am selecting any Student who did not submitted the Fee the table visual display Empty.
While I am expecting Total fee submitted for the department Associated with that Student

Agian, kindly requesting to provide a screenshot of the visual to better understand the problem.

Solution Sage
Solution Sage

please Share your Data modeling of Table for batter understanding!! Thank You!!


I have only 1 table "Student"
and I appended all others tables in this Student table.

Helpful resources

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

MPPC 2023 PBI Carousel

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors
Top Kudoed Authors