Change grand total of a column for an specific value

[Anonymous]

Hi, I have a colum with the grades of different students but i need the total of that column to be 100. I use a measure with Max for Grades since 100 is the Max of the column Grade. The issue is that when I use a filter, in this case a date filter, not always the max is 100. I need the measure to obtain the max of the entire column grade without filter regardless if I have a filter or not.

Grades = CALCULATE(max('Table Grades'[Grades]))

Date	Name	Grade
12/2/2019	Solano Chaves Bernal	60
12/2/2019	Lopez Pérez Fiorella	70
12/2/2019	Chaves Martínez Jesús	90
12/2/2019	Paz Granados Jorge	80
12/2/2019	Garita Hidalgo Diego	85
12/2/2019	Barquero Valverde Alvaro	96
Total		96

[Anonymous · Accepted solution]

Perhaps you can remove all filters if there is no filter on name?

Grades =
IF (
    HASONEFILTER ( 'Table Grades'[Name] ),
    MAX ( 'Table Grades'[Grades] ),
    CALCULATE ( MAX ( 'Table Grades'[Grades] ), ALL ( [Table Grades] ) )
)

Don't know if this is what you were looking for, but perhaps it can give some input.

[Anonymous]

Hi @Anonymous thanks a lot, that was what I need.

[amitchandak]

try = Grades = round(CALCULATE(max('Table Grades'[Grades])),-2)

or see if ceiling can help

https://docs.microsoft.com/en-us/dax/ceiling-function-dax