Forum Discussion

kipi_bi's avatar
kipi_bi
Frequent Visitor
9 months ago
Solved

Problem with MAXX

Hello Team,   I am trying to get the Maximum Score achieved by any Employee but it is getting filtered at employee level ,even after applying additional filters with ALL and REMOVEFILTER, there is ...
Need Help
  • Ahmedx's avatar
    Ahmedx
    9 months ago

    pls try

    MaxTotalScorePerEmployee =
CALCULATE(
    MAXX(
        ADDCOLUMNS(
            SUMMARIZE(
                ALL(Dim_Employee),
                Dim_Employee[EmployeeID]
            ),
            "TotalScore", CALCULATE(SUM(FactEmployee_Training[Score]))
        ),
        [TotalScore]
    ),
    REMOVEFILTERS()
)
---------------or-------------
MaxTotalScorePerEmployee =CALCULATE(
MAXX(
    TOPN(
        1,
        ADDCOLUMNS(
            SUMMARIZE(
                ALL(Dim_Employee),
                Dim_Employee[EmployeeID]
            ),
            "TotalScore", CALCULATE(SUM(FactEmployee_Training[Score]))
        ),
        [TotalScore],
        DESC
    ),
    [TotalScore]
),
    REMOVEFILTERS()
)
Rufyda's avatar
Rufyda
Super User
9 months ago

Max Score All Employees =
CALCULATE(
MAX(Fact_employee_training[Score]),
REMOVEFILTERS(Dim_Employee)
)

MAX(Fact_employee_training[Score]) finds the highest score in the fact table.

REMOVEFILTERS(Dim_Employee) ignores all filters from the employee dimension, giving the maximum score across all employees regardless of employee-level filters.

 


If this response was helpful, please accept it as a solution and give kudos to support other community member.