Forum Discussion
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
Super User
Super UserAnonymous , You need to have measure like
example
calculate([revenue measure], all())
or
calculate([revenue measure], all([main fact table]))
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")