CODEWITHSUNDEEP
powerbidax
Alex
Alex

Reputation: 159

Is there a way to put calculated column in ALL()?

I'm trying to remove filters from a calculated column with ALL(), and the measure seems to ignore it

Example for the visual

"Class" is a calculated column. I want to add measure always showing 100 (the grand total) There are outer filters on the table so I don't want to use ALL(TABLE) However, CALCULATE(SUM([Total Sales]), ALL(Product, Class)) doesn't work.

Upvotes: 0

Views: 48

Answers (1)

Alexis Olson
Alexis Olson

Reputation: 40204

You can use the ALL() function on a list of columns like this:

CALCULATE ( SUM ( Table1[Sales] ), ALL ( Table1[Product], Table1[Class] ) )

This should work fine even if Class is a calculated column.

Upvotes: 1

Related Questions