Forum Discussion
Measures - Row Level vs the Table Level
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%
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
4 Replies
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
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')) ))).
- Sorry, please exchange semicolons by commata ... I have to use semicolons because of regional operating system reasons i guess.
