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 =
This shall also provide the same result
Fee Submitted = CALCULATE ( SUM ( 'Student'[FeeSubmitted] ), ALL ( 'Student'[Name] ), VALUES ( 'Student'[Department] ) )
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 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
Take a look at the September 2023 Power BI update to learn more.
Join Microsoft Reactor and learn from developers.
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!
Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.