Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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)'),
FILTER(
'table - Fichas (Entrada e Saída)',
'table - Fichas (Entrada e Saída)'[Data_Entrada] <= LASTDATE(dCalendario[Data])
&&
('table - Fichas (Entrada e Saída)'[Data_Fim] >= FIRSTDATE(dCalendario[Data])
|| 'table - Fichas (Entrada e Saída)'[Data_Fim] = BLANK())
),
'table - Fichas (Entrada e Saída)'[Materia_Tipo] = 3,
'table - Contratos'[Ativo] = 1,
'table - Contratos'[Classe_Contrato] = "O",
'table - Fichas (Entrada e Saída)'[Fase_Cod] <> 67 && 'table - Fichas (Entrada e Saída)'[Fase_Cod] <> 101,
'table - Fichas (Entrada e Saída)'[N_Contrato] <> BLANK()
)
* 'table - Fichas (Entrada e Saída)'[.Valor unitário]
)
This measure is ok, when I put it in a yy/mm matrix, it brings me the total result per month correctly, but I would like to add these monthly results to have the annual total.
Instead:
I would like this:
Could someone give me some help?
Solved! Go to Solution.
I would use a If clause:
IF(HASONEFILTER(yy/mm),"_your regular function for yy/mm","_how you calc the total")
Proud to be a Super User!
I would use a If clause:
IF(HASONEFILTER(yy/mm),"_your regular function for yy/mm","_how you calc the total")
Proud to be a Super User!
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")
)
User | Count |
---|---|
54 | |
23 | |
19 | |
18 | |
17 |
User | Count |
---|---|
91 | |
87 | |
47 | |
28 | |
22 |