CODEWITHSUNDEEP
powerpivotdax
John Donnelly
John Donnelly

Reputation: 917

DAX Need Power Pivot Measure to be SUM of ALL Columns in Each Column. How to ignore column context

I have a Pivot Table with Salespeople as columns. I have income measures that correctly show (in the rows) the income each of them produced. However, I would like to show everyone's income in each column on some of the measures.

The reason is I want them to be paid on some income items (row measures) on the total of all salespeople not on their individual production.

Is there a way to make a measure ignore the column context?

Upvotes: 0

Views: 200

Answers (1)

Krystian Sakowski
Krystian Sakowski

Reputation: 1653

DAX ALL

Try to use ALL function and give your column as a parameter.

It will clear currently applied filters.

Upvotes: 1

Related Questions