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 consider...
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")