ALL FUNCTION NOT WORKING

[Anonymous]

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

[amitchandak]

@Anonymous , You need to have measure like

example

calculate([revenue measure], all())

or

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

[Anonymous]

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