Maximum cardinality exceeded error

I am also facing the similar issue,
Getting the error: “Maximum cardinality exceeded (3,460,343,100 > 1,000,000,000)”
(IF(('Relocated?'),'Goal Value',0))
If relocated is true, then return goal value, else 0.
Source Metric and target metric are having dimensions: Employees, projects, integers 

Can anyone please let me know how to resolve the cardinality issue?
 

Hi @pigment_enthusiast ,

You can avoid the 0 in the second argument as it is not needed to set a second argument in the IF statement:
IF('Relocated?','Goal Value'), this will result in blanks instead of zeros which will help you avoid the Maximum Cardinality error and take advantage of Pigment sparsity.
here is the article as well to understand how pigment handles sparsity.

Hope this helps 

It has resolved now, thanks @Issam Moalla .
 
I have another metric wherein i have the formula, Getting cardinality issue.
IF('Position' <> 1 AND (ISBLANK('Not Relocated?') OR ('Not Relocated?' = FALSE)),TRUE)
 

Hi!

I’m also facing the same issue: Maximum cardinality exceeded (96,303,838,267 > 1,000,000,000)

'Total_Stats FTE'[filter:'SET_Include TBH Status in FC'][exclude:currentvalue=0] (pull from total stats fte metric to filter true values). I thought excluding 0 values would help but nothing’s changed. What might be the issue?

Thanks.