So I am trying to create a count of policies, but there is one type of policy that needs to be counted twice. I have two separate calculations that work, but am having trouble writing a calculation that tells Tableau to calculate one or the other.
COUNT (IF [PartnerID] <> 'XX' THEN [PolicyNumber] END)
COUNT (IF [PartnerID] = 'PL' AND [Policy Summary] = 'BUNDLE' THEN [Coverage Id] END) * 2
Anyone have any idea how I could combine these two into one conditional calculation?