Answered

Where am I going wrong with the sum filter function?

(0) Share

Report

Posted on by lmcc

I have a dataverse table which one column as a choice column. I have a second column with points. I want to sum points where the choice column = 5D.

Sum(
Filter(
Students,
Class = Class.Value.5D
),
Points
)

This formula isn't working. Where am I going wrong?

Categories:

Building Power Apps

All responses (9)

Answers (1)

Sort by

Ami K 15,689 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@lmcc ,

For a Local Choice, use:

Sum( Filter( Students, Class = 'Class (Your Table Plural Name)'.SD ), Points )

For a Global Choice, use:

Sum( Filter( Students, Class = [@'Your Global Choice Name'].SD ), Points )
lmcc 77 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

can you tell me what .SD means?

as of yet it isn’t working.

Thank you,
Ami K 15,689 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@lmcc - looks like my eyes are getting old - I read "S"D instead of "5"D.

"Isn't working" is not very descriptive.
lmcc 77 on at

Like
a
(0)

Report
Copy link

Link copied!

I agree, I apologise for my bluntness.

The formula isn't working for some reason displaying this error.

I may need to convert an argument so the match can occur. But this is causing me a headache. I can't figure it out at all.

Kind regards
Ami K 15,689 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@lmcc - that is not the formula I proposed.

Could you please confirm if your Choice field is a Local Choice or a Global Choice.
lmcc 77 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi There,

Thank you for responding.

The choice is global.

How might this change your formula?
Verified answer

Ami K 15,689 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@lmcc - I already provided it above - you just need to use it instead of doing whatever it is your doing.

Sum( Filter( 'Your Table', Class = [@'Your Global Choice Name'].5D ), Points )

If you're still struggling, please take a screenshot of your Global Choice field and the Lookup field in your Dataverse column which references the Global Choice field. Example below:
lmcc 77 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

Thank you for your perseverance.

Unfortunately, it didn't work with your suggestion. However, this did:

AddColumns(
GroupBy(
AddColumns(
Students,
"yourNewStatus",
Text('Academic House')
),
"yourNewStatus",
"Statuses"
),
"Totals",
CountRows(Statuses)
)

I'm wondering why?
Ami K 15,689 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@lmcc - again - "it didn't work" is not descriptive. Is there an error for example?

If you do indeed have a Dataverse Choice column in your Table, and that column is a Lookup to a Global Choice field, the solution provided will work.

I suspect there is something going on with your Table and/or App which you have not clarified.

I would not recommend using the AddColumns and GroupBy functions, they are not delegable and are completely unnecessary for this scenario.