Forum Discussion
Solved
Colunm total
Hello, I'm having trouble totaling. I have the following: .Valor por Fichas Contencioso = SUMX( 'table - Fichas (Entrada e Saída)', CALCULATE( COUNTROWS('table - Fichas (Entrada e Saída)'), ...
I would use a If clause:
IF(HASONEFILTER(yy/mm),"_your regular function for yy/mm","_how you calc the total")
andhiii079845
Solution Sage
Solution SageI would use a If clause:
IF(HASONEFILTER(yy/mm),"_your regular function for yy/mm","_how you calc the total")
Cool, I went ahead with your tip! Grateful!
Now the other question: how to add the result of each month?
Can you help me with this? I can't find a logic for this...I found the solution. I applied the following under the condition of accumulating the monthly result to form the total:
IF(
HASONEFILTER(dCalendar[mm/yy]),
SUMX(
"regular condition for mm/yy"
),
SUMX(VALUES(dCalendar[mm/yy]), "measure that totals mm/yy")
)
