Help in Table and Measures

[Anonymous]

Greetings everyone,

I have a table with the sales amount planned and realized by several products and customers.

Table Example 

I was able to create a table where I show the sum of these values in two columns (OBJ and REALIZADO). And I also created a column where I show the variation between these values in %.

PBI Example 

My doubts are:

1) How to not show the rows where the following conditions occur

• OBJ = 0 and REALIZADO = 0
• OBJ = 0 and REALIZADO = BLANK
• OBJ = BLANK and REALIZADO = 0

2) When OBJ = 0 or BLANK, but REALIZADO is neither, COBERTURA is 0%. How to get 0% when REALIZADO = 0 or BLANK, but OBJ is neither.

3) How could I create a table of Customers, showing the average COBERTURA?

In Março, for Customer 1, I had sales of two products, 50048 and 50049, with COBERTURA of 0% and 38.5%.

In this new table, I would like to show that the assertiveness was (38.5 + 0.0) / 2 = 19.25%

Best Regards,

[MFelix · Accepted solution]

Hi @Anonymous ,

Create the following measure:

Filter = if(([OBJ] = 0 && [REALIZADO] = 0) ||([OBJ] = BLANK() && [REALIZADO] = 0) || ([OBJ] = 0 && [REALIZADO] = BLANK()), BLANK(), 1)

Now add this measure to your table and filter all values that are different from blank.

For the average create the following measure:

Av Cobertura = AVERAGEX(SUMMARIZE(Plan2, Plan2[Cliente Matriz], Plan2[Produto],"CoberturaValue", [COBERTURA]), [CoberturaValue])

Result below and in attach PBIX: