Forum Discussion

rcardenasbc's avatar
rcardenasbc
Frequent Visitor
2 years ago
Solved

Problem with Total column in visual matrix

I have a problem with a matrix visual in Power BI, the data obtained with a DAX is correct but the Total column only shows December and should total everything, what should I do to make it add up all...
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi rcardenasbc ,

    Based on the description, try to add the following DAX formula.

    VAR Result =
        IF(
            ISBLANK(Valor),
            0,
            Valor
        )
    
    VAR TotalResult =
        IF(
            HASONEVALUE('DAX Calendar'[MesNumero]),
            Result,
            SUMX(
                VALUES('DAX Calendar'[MesNumero]),
                Result
            )
        )
    
    RETURN
        TotalResul

    Viewing the following document to learn more information.

    HASONEVALUE function (DAX) - DAX | Microsoft Learn

     

    Best Regards,

    Wisdom Wu

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.