Help with SUMX and SUMMARIZE

[ThalesFerraz]

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:

IMG 2:

[Eric_Zhang]

@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.