Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Bruno_OMB
Regular Visitor

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)'),
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:

Bruno_OMB_0-1678218221866.png

 

I would like this:

Bruno_OMB_1-1678218257283.png

 

Could someone give me some help?

1 ACCEPTED SOLUTION
andhiii079845
Super User
Super User

I would use a If clause: 
IF(HASONEFILTER(yy/mm),"_your regular function for yy/mm","_how you calc the total")





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

3 REPLIES 3
andhiii079845
Super User
Super User

I would use a If clause: 
IF(HASONEFILTER(yy/mm),"_your regular function for yy/mm","_how you calc the total")





Did I answer your question? Mark my post as a solution!

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")
)

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.