Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Help in Table and Measures

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 ...
Need Help
Show and Tell
Tips and Tricks
  • MFelix's avatar
    MFelix
    5 years ago

    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:

     

MFelix's avatar
MFelix
Super User
5 years ago

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: