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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

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.

Top Solution Authors