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
ThalesFerraz
Helper III
Helper III

Help with SUMX and SUMMARIZE

Hello,

 

I have 2 meansures.

The first measure, named #Dias Trabalhados Meta counts how many days should have worked.
If the number of days is greater than 22, then the meansure returns 22.

Note: This measure ignores which teams worked. the total number of days worked is should be the same for all teams.

 

The second measure, names #Equipe Efetiva create a table and returns the #Dias Trabalhados Meta for each team.

 

Reason: I want the #Dias Trabalhados Meta for each team and a total adding up the #Dias Trabalhados Meta of all team using the measure #Equipe Efetiva.

Problem: Using #Dias Trabalhados Meta the value of all lines of a table is right, but the total is wrong.

Using #Equipe Efetiva the value of all linhes is wrong, but the total is right.

 

 

What should I do to fix this?

 

 

 

#Dias Trabalhados Meta = 
	SUMX(CALCULATETABLE(SUMMARIZE('IP OS ENCERRADA';
		"MAXIMO"; 22; 
		"DIAS"; [#Dias Trabalhados]); 
		FILTER(ALLSELECTED('IP OS ENCERRADA'); [COD_EQUIPE] > 0)); 
	IF([DIAS] >= [MAXIMO]; [MAXIMO]; [DIAS]))

 

 

 

#Equipe Efetiva = 
	SUMX(CALCULATETABLE(
		SUMMARIZE('IP OS ENCERRADA'; [Competência]; [COD_EQUIPE];
			"META"; [#Dias Trabalhados Meta]); 
		FILTER('IP OS ENCERRADA'; [COD_EQUIPE] > 0));
	[META])

 

IMG1:

1.png

IMG 2:

2.png

Sincerely,
Thales Ferraz
1 REPLY 1
Eric_Zhang
Employee
Employee

@ThalesFerraz

I don't have your data to test, according to your description, creating a 3rd measure as below and puting it in the table visual might work.

 

3rd Measure =
IF (
    ISFILTERED ( 'IP OS ENCERRADA'[COD_EQUIPE] ),
    [#Dias Trabalhados Meta],
    [#Equipe Efetiva]
)

If it doesn't work, please post some sample data.

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.