Calculated field to show subtotal value

[bthomas]

I could be going about this all wrong and this may be why I am unable to find any information on this topic, but I am trying to create a calculated field that gives the subtotal value in a column. My ultimate goal is to get the percent of the subtotal value for each item.

I created a simple table named Grades (for learning Power Pivot). The table has the following fields.

Type
First
Last
Current Points
Total Points

I would like to create a column that totals the Current Points based on Type.

My current table looks like the example below with the calculation scenarios added. When I create the Current Points formula based on Type, it repeats the Current Points column. This is the formula I am using.

By Type:=CALCULATE([Total],Grades[Type]=Grades[Type])

Please let me know if you have any suggestions. Your help is greatly appreciated!

Type	First	Last	Current Points	Total Points	The calculation I would like.	The calculation I am getting.
Female	Shauna	Thomas	400	1000	650	400
Male	Logan	Thomas	350	1000	550	350
Male	Jay	Shaw	200	1000	550	200
Female	Wendy	Dem	250	1000	650	250

<tbody>
</tbody>

 

[Matt Allington]

Try this

=calculate([Total],all(tablename),values(tableName[type]))

read about values here https://powerpivotpro.com/2014/08/the-many-faces-of-values/

 

[zapppsr]

Create a Measure [TotalCurrentPoints] =SUM(Grades[Current Points])

Create a Column:

=CALCULATE(CALCULATE([TotalCurrentPoints];ALL(Grades);VALUES(Grades[Type])))

You need two calculate for context transition and values to filter for type. Also need all to get the whole table.

I hope it helps.

 

[zapppsr]

Create a Measure [TotalCurrentPoints] =SUM(Grades[Current Points])

Create a Column:

=CALCULATE(CALCULATE([TotalCurrentPoints];ALL(Grades);VALUES(Grades[Type])))

You need two calculate for context transition and values to filter for type. Also need all to get the whole table.

I hope it helps.

PS: Just change the ";" for ","

 

[bthomas]

Thank you all for your help!