Forum Discussion
Help in Table and Measures
Greetings everyone,
I have a table with the sales amount planned and realized by several products and customers.
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 %.
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,
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:
1 Reply
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: