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.