Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

ALL FUNCTION NOT WORKING

Hi.

I created a calculated field using ALL function and when I show all the informations it works well.
The problem is when I filter.
The total sum of revenue "R$ Fat. TTL (ALL)" is not considering "SEM COR".

 

 

2 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    4 years ago

    Anonymous , You need to have measure like

     

    example

    calculate([revenue measure], all())

     

    or

     

    calculate([revenue measure], all([main fact table]))

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Hi amitchandak .

      I already have a measure like that.
      The table where I'm using this measure contain one information that is blank actually (named "SEM COR").
      I don't know why when I filter only one color in the table the total sum of the colors does not consider the blank value. So, the sum of the colors only consider the colors green, yellow, orange, red and black. Ignoring the blank value ("SEM COR")