March 2019
Beginner
504 pages
11h 17m
English
Let's say you created a Discount % (row-level) calculation with the following code:
[Discount] / [Rent]
The code differs from the aggregate calculation you created previously, which had the following code:
SUM([Discount])/SUM([Rent])
Here is the dramatic difference in results:

Why is there such a difference in the results? It's a result of the way the calculations were performed.
Notice that Discount % (row-level) appears on the Measure Values shelf as a SUM. That's because the calculation is a row-level calculation, so it gets calculated row by row and then aggregated as a measure after ...
Read now
Unlock full access