Segmentation of Data in Tables (Hiding Data)

[disipebr]

Hello Partners,

I've tried every way and I can not solve what's a problem for me.

I have a table that compares data between 2 months closed. From this table, I had to create 4 calculated measures to make the comparisons right. (I emphasize what were the measures, according to print)

I am facing two problems, which compared to SAP Business Object, did not occur.

There is a join between two tables by the name of the column "[Empresa]"

Here is my difficulty:

1 - Clicking on the segmentation of data that is divided into two groups, one being the month that I am comparing and the other being the [Empresa] that I want to filter, it brings all [Empresa], but only the data of those companies that are in the week [Segmentation 2]. I need to hide the other [Empresa] to not pollute the vision (Leaving only rows that have all the data filled in, Similar Excel). it is possible ?

2 - Something that I noticed when creating a calculated measure, using for example some IF conditions, and giving the measure output as Text, when trying to use this measure on some chart, it does not respect the same segmentation brought in a table. Ex: the measure Campara Meta = IF(OR([Meta Atingida]=[Soma Meta Q];[Meta Atingida]<=[Soma Meta Q]);"Dentro da Meta";IF([Meta Atingida]>[Soma Meta Q];"Fora da Meta";"Fora de Escopo"))

(My expectation would be to place the calculated measure that counts all the rows and split and show on the pie chart by the same segmentation applied in the table, with 3 output types)

Thanks !

[Thyago_Rezende]

Hi @disipebr,

You can try to follows cod:

SWITCH(
   True();
   COUNTROWS(EMPRESA) > 0 && Meta Atingida <= Meta Q; "Dentro da Meta";

   "Fora de Meta")

Best Regards,

Abraços 😉