Dax measure value constant for all entities

0
votes

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
1
powerbidax

1 Answers

3
votes

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