topic Re: Pick Department on the Bases of Student Selection From dropdown and Sum over All fee submitted in DAX Commands and Tips

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

Anonymous — Mon, 15 May 2023 09:04:18 GMT

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.

Detail
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 =

SELECTEDVALUE('Student'[Name])

VAR AssociatedDEPT =

CALCULATE(

VALUES('Student'[Department]),

'Student'[Name] IN SelectedStudent

)

RETURN

CALCULATE(

SUM('Student'[FeeSubmitted]),

'Student'[Department] IN AssociatedDEPT

Your quick response will he highly appriciated

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

Mahesh0016 — Mon, 15 May 2023 09:16:46 GMT

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

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

tamerj1 — Mon, 15 May 2023 09:18:08 GMT

Hi Anonymous
Please try

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

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

Anonymous — Mon, 15 May 2023 09:52:17 GMT

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

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

Anonymous — Mon, 15 May 2023 09:57:26 GMT

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.

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

tamerj1 — Mon, 15 May 2023 10:01:54 GMT

Anonymous
This shall also provide the same result

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

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

tamerj1 — Mon, 15 May 2023 10:06:28 GMT

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

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

Anonymous — Tue, 16 May 2023 04:57:41 GMT

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

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

tamerj1 — Mon, 15 May 2023 10:54:17 GMT

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