Forum Discussion

Altonga's avatar
Altonga
Frequent Visitor
3 years ago
Solved

Max Function Aggregate

Hello all,   I'm having some issues with a training tracker that I am building, I want to track progress of students from 'tests' that they carry out.    Test1 = 10% Test2 = 20% Test3 = 30% Te...
aggregate
DAX
Max
  • tamerj1's avatar
    tamerj1
    3 years ago

    Altonga 

    Please try

    %Trained =
    AVERAGEX (
    VALUES ( 'Results'[Chapter] ),
    CALCULATE (
    AVERAGEX (
    VALUES ( 'Results'[Subchapter] ),
    CALCULATE (
    MAX ( 'Results'[Test1%] ) + MAX ( 'Results'[Test2%] )
    + MAX ( 'Results'[Test3%] )
    + MAX ( 'Results'[Test4%] )
    + MAX ( 'Results'[Test5%] )
    )
    )
    )
    )

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Can you try to use (show value as Percent of Grand Total) in the Visualization.