Measures - Row Level vs the Table Level

[comish4lif]

I have a measure that calculates properly at the row level.

LeagueR1Bi =
DIVIDE(SUM('Table 0'[R1_BI]), SUM('Table 0'[R1]))

But I also want to have a version of that calculation at the table level. That is, the sum of all values in the column R1_BI dividied by the sum of all values in the column R1. If I do not select a row to highlight/filter, the calculation displays and calculates correctly.

However, if I want to compare the row's calculation to the table's calculation, it will only show the row calculation.

How can I compare the row calculation to the table calculation?

For example, in one row - the values would be 63/392 = 16.1%,

but for the entire table, the values would be 6957/51801 = 13.4%

[DaFloDo · Accepted solution]

hi @comish4lif,

try 

TableMeasureIgnoreFilter = DIVIDE(calculate(SUM('Table 0'[R1_BI]); All('Table 0')); CALCULATE(sum('Table 0'[R1]);ALL('Table 0')) )

best regards

florian

[comish4lif]

That is giving me an error - It doesn't like one of the semi-colons.

The syntax for ';' is incorrect. (DAX(DIVIDE(calculate(SUM('Table 0'[R1_BI]);All('Table 0'));CALCULATE(sum('Table 0'[R1]);ALL('Table 0')) ))).

[DaFloDo]

Sorry, please exchange semicolons by commata ... I have to use semicolons because of regional operating system reasons i guess.

[comish4lif]

That's it - thanks, for those in the US:

LeagueR1BI = DIVIDE(calculate(SUM('Table 0'[R1_BI]),All('Table 0')),CALCULATE(sum('Table 0'[R1]),ALL('Table 0')) )