cancel
Showing results for
Did you mean:

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

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 =
"MAXIMO"; 22;
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:

Sincerely,
Thales Ferraz
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] ),
[#Equipe Efetiva]
)```

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

Announcements

New forum boards available in Real-Time Intelligence.

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

Power BI Monthly Update - May 2024

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

Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors