Hi,

First post, I will try to be clear.

I am trying to calculate levies. The levies are calculated by market share x licence fees paid (aka the SAC)

So SAC x Market Share = Levy paid.

with a floor charge of $50.

So I have done two measures as follows:

[Levy = floor] = IF( [Levy] < 50, 50, BLANK()) // Levies paying floor

[Levy > floor] = IF( [Levy] > 50, [Levy], BLANK()) // Levies paying > floor

Now I want to sum the levies that are paying $50.00, and those that are paying more, to get two separate amounts.

It is late, but I am getting confused at why a measure canâ€™t just show me the total value when I drag in a card.

Perhaps I should be doing this all in code and variables?

Thanks in advance for any assistance.