Answered

Sum Columns Based on Text Box VAlue

(0) Share

Report

Posted on by PPanfili

Ok here is my situation.

I have a Table titled ALL. I have a column in the table named Points_Assigned. I also have another column named Last_Name and First_Name.

As you can see in my attachment, I then have a Textinput box, that I want to use a Sum function on, to calculate the total points given, for the student that is chosen in the first and last name textboxes.

The formula I am trying to use is as such....CALCULATE(Sum('All'[Points_Assigned]);'ALL'[Last_Name] = Nameinput.text;'All'[First_Name] = FirstNameInput.text)

However I am getting an error that says Invalid ArguementType Table, Expecting a Number Value Instead.

I have tried so many different iterations of this, but cannot get a sum function to work here.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

CarlosFigueira Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
You should combine the Filter function (to limit the items for the given student only) with the Sum function (to actually perform the sum). Something like the expression below should work:
Sum( Filter( 'ALL', Last_Name = NameInput.Text, First_Name = FirstNameInput.Text), Points_Assigned)

Was this reply helpful? Yes No
Nikhita 6 on at

Like (0)

Report
Copy link

Link copied!

Hi,

I am trying to implement similar functionality, except that I need to do a summation of column selected in a dropdown. Below is an example of what I am trying to achieve -

Name    Level    Week1    Week2    Week3
A    X    5 3 2
B    Y    2 5 5
C    X    1 2 0

I have a dropdown that has values as - "Week1", "Week2", "Week3". If I select "Week1" in my dropdown, it should calculate sum total of Week1 values based on Levels. Table name is "MyTab". Output should be as follows for Week1:

Level X - 6
Level Y - 2

I used the below formula, but it ain't working.

Sum (Filter (MyTab, Level = 'X'), dropdown.selected.result)

Any help on this would be appreciated. Thank you!

Was this reply helpful? Yes No