IssueWhen you try to view underlying data, the following error might occur:
Invalid expression, cannot be unaggregated.
IF THEN ELSE ENDstatement instead of
COUNT(). For example use:
IF [<SetName>] = true THEN 1 ELSE 0 ENDInstead of:
IF [<SetName>] THEN [Sales] ENDReplace the calculated field with Sales and drag <Set Name> to the Filters shelf.