CODEWITHSUNDEEP
powerbidax
vandelay
vandelay

Reputation: 2075

Dax measure value constant for all entities

If I have a simple table as below

Department    User  Sale
    IT         A      25
    IT         B      25
    DA         C      25

Is it possible to create a measure that would keep the sum of sale fixed for each User. So that in a table visual it would appear as:

 Department   User  SaleMeasure
    IT         A     50
    IT         B     50
    DA         C     25

Upvotes: 0

Views: 5841

Answers (1)

Alexis Olson
Alexis Olson

Reputation: 40204

Yes, you just need to remove the User filter context if you don't want to use it.

SalesMeasure = CALCULATE(SUM(Table1[Sale]), ALL(Table1[User]))

This matches your stated output either as a measure or a calculated column:

SaleMeasure SaleColumn

Upvotes: 3

Related Questions