Forum Discussion
Solved
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 ...
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
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.
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')) )