How to put COUNT within IF

[Syndicate_Admin]

Good afternoon!

I explained my problem.

I have this column with several values:

The values in this column can be: 001N, 002N, 003N, 004N, 005N.

Depending on the value, you have to do the following:

If Code Nuevas = 001N, then COUNT(Opportunity[Opportunity] * (0.10)

If Code Nuevas = 002N, then COUNT(Opportunity[Opportunity] * (0.15)

If Code Nuevas = 003N, then COUNT(Opportunity[Opportunity] * (0.50)

If Code Nuevas = 004N, then COUNT(Opportunity[Opportunity] * (0.20)

If Code Nuevas = 005N, then COUNT(Opportunity[Opportunity] * (0.05)

How can I do this to make it work out for me?

I've tried it to one extent (the IF doesn't work with columns for me)...

Can you help me please?

Thank you!

[Greg_Deckler · Accepted solution]

@Syndicate_Admin Use SWITCH like:

Measure = 
  VAR __Code = MAX('Table'[Code Nuevas])
RETURN
  SWITCH(__Code,
    "001N",COUNT(Opportunity[Opportunity])*.1,
    ...
  )