Monday, 2 May 2016

Difference between Aggregate & Non-Aggregate Measures


AGGREGATED MEASURES

Aggregate measures means implementing one of the Arithmetic Calculations.
It means After the calculations.

EX: Sum((Sales])

If you want to filter the data where Sales volume is more than 2000000 after the calculation then we can use the following approach.

If Sum([Sales])  >= 2000000 then "Show" end


NON-AGGREGATED MEASURES

NON-AGGREGATED MEASURES means without using the any kind of Arithmetic Calculations.

EX: (Sales])


No comments:

Post a Comment