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()
)
kipi_bi's avatar
kipi_bi
Frequent Visitor
9 months ago

Thanks a lot, it worked 

Can you let me know why we need to add ADD COLUMNS to get the answer ?

 

Regards,

Ritz