Sum based on Active Filters

[zhejun728]

I'm a user of Tableau but a totally new user of Power BI.

Im trying to create a new column to show the sum of COST which can be affected by active filters on visual.

I have a sample data as below.

item	ITEM GROUP	COST
SEATCOVER	VICTRON	9
WASHER	GCMSB	0.5
NUT	GCMSB	1
COLLAR	CW	5
SHAFT	GCMSB	7
COVER	BL	10

My expected outcome in Power BI whgen no active filters applied.

item	ITEM GROUP	COST	Total Cost
SEATCOVER	VICTRON	9	32.5
WASHER	GCMSB	0.5	32.5
NUT	GCMSB	1	32.5
COLLAR	CW	5	32.5
SHAFT	GCMSB	7	32.5
COVER	BL	10	32.5

When ITEM GROUP is not GCMSB.

item	ITEM GROUP	COST	Total Cost
SEATCOVER	VICTRON	9	24
COLLAR	CW	5	24
COVER	BL	10	24

If possible, I wish there is no hard coding in the command line, and can works dynamically with the active filters.
Thanks !!

[Anonymous · Accepted solution]

Hi @zhejun728 ,

I create a table as you mentioned. Also I created a Slicer.

As tamerj1 said, you can create a measure and here is the DAX code.

Total Cost =
CALCULATE ( SUM ( 'Table'[COST] ), ALLSELECTED ( 'Table' ) )

Finally you can get what you want.

Best Regards

Yilong Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[zhejun728]

Thank Yilong ! That's help !!

[tamerj1]

Hi @zhejun728 

please try

Total Cost =
CALCULATE ( [Cost], ALLSELECTED ( ) )

[zhejun728]

Thanks @tamerj1 😁