Fundemental understanding of measures - % of total calculation

[NNaj]

Hi All,

Im trying to calculate the % of total. i.e. (win value / total value)

Here is my table.

% of total business = [Win Value]/SUM(DEXTR[Absolute value of trades])

The card at the bottom displays the total value of trades correctly. the measure for this is:

Total Value of Trades = CALCULATE(SUM(DEXTR[Absolute value of trades]))

Why is my first row appearing as 13,250,000 / 13,250,000 (therefore showing 100%) rather than 13,250,000 / 458,000,000?

How can I fix this?

Thank you in advance for the help!

[Nathaniel_C · Accepted solution]

Add ALL to Total Value of Trades = Total Value of Trades = CALCULATE(SUM(DEXTR[Absolute value of trades]))

Total Value of Trades = CALCULATE(SUM(DEXTR[Absolute value of trades]),ALL(DEXTR))

Hi @NNaj ,

Try adding ALL to your measure.  Right now on each line this is being filtered.
Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel