Forum Discussion

LuizPoleza's avatar
LuizPoleza
Frequent Visitor
1 year ago

Matrix and tables total incorrect

Hello there, I need some help   One of my users noticied that the totals being shown on matrix (and I tried on a table, same wrong results) are wrong. See the example below. It is "missing" 1 quan...
Need Help
AmiraBedh's avatar
AmiraBedh
Super User
1 year ago

You should use a measure and not a calculated column, the total row does not simply sum the visible rows; instead, it evaluates the DAX formula in the total context :

My Measure = SUMX(
    FILTER(
        FuncionariosAtivos,
        FuncionariosAtivos[Realizado] >= 0
    ),
    FuncionariosAtivos[Realizado]
)

 

 

LuizPoleza's avatar
LuizPoleza
Frequent Visitor
1 year ago

Hi AmiraBedh 

Thank you so much for your time. I really appreciate.

 

I am not using a calculated collumn. "Realizado" is a DAX measure.

I didn't understood. Can you further elaborate?