cancel
Showing results for
Did you mean:
Regular Visitor

## sum measure flag

Hi everybody,

I have a table that is grouped by  "Distribuidores" and "Anunciantes". The meausures of the table are "Facturado Current  Year" and "Facturado Last Year". I want to know the percent of "Anunciantes" that were lost and earned over the year. So, for the "Anunciantes " lost I need to calculate the "Anunciantes" that were in LY but they are not in the current year. And for the anunciantes earned I need to calculate the "Anunciantes" that are in the current year but not on the last year.

The table is below. I made a flag that is 1 when the "Anunciante" are in LY but aren't in the current year. For the "Anunciantes" earned I mad the opposite.

My idea is sum the flags and divide by the total of rows. The problem is that I can't sum up a meausure or I don't know how to do it. Can you help please?

I exported the table. Var is Flag_1 and var3 is Flag_2 https://drive.google.com/file/d/1866-h9C99vdXrYqyeSrLhnlFGZsXSG4n/view?usp=sharing

2 REPLIES 2
Highlighted
Established Member

## Re: sum measure flag

Hi @marijane12

will this code give you what you need?

```percentage new =
DIVIDE (
CALCULATE (
DISTINCTCOUNT ( data[Anunciante] );
FILTER (
data;
OR ( ISBLANK ( data[Facturado LY] ); data[Facturado LY] <= 0 )
&& NOT (
ISBLANK ( ( data[Facturado] ) )
)
)
);
CALCULATE (
DISTINCTCOUNT ( data[Anunciante] );
FILTER ( data; NOT ( ISBLANK ( data[Facturado] ) ) && data[Facturado] > 0 )
)
)```

I have reused some of the code you had put into the flags

Regular Visitor

## Re: sum measure flag

it wasn't exactly what I wanted but it helped! Thank tou! @sturlaws

Announcements

#### Community Highlights

Find out what's new in the Power BI Community!

#### Power Platform Summit North America

Register by September 5 to save \$200

#### Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

#### Watch Sessions On Demand!

Continue your learning in our online communities.

Top Kudoed Authors
Users Online
Currently online: 329 members 3,218 guests
Recent signins: