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%] )
    )
    )
    )
    )

Altonga's avatar
Altonga
Frequent Visitor
3 years ago

Hi,

As you can see below for the first student 120% is correct for how much they have scored over all of the subcategories but I am after an aggregation of this so in theory Student one would be displaying 10%. Apologies as my knowledge isn't very extensive but hoping it would be an easy fix!

tamerj1's avatar
tamerj1
Community Champion
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%] )
)
)
)
)