ATTR Function use

 

If we want to show sum for a particular segment, avg for another segment,

Ratio for the other segment in a single calculation then we use the ATTR Function.

  IF ATTR([Segment])='Consumer'  THEN SUM([Profit])
ELSEIF ATTR([Segment])='Corporate'   THEN avg({ INCLUDE [Category]:SUM([Sales])})
ELSEIF ATTR([Segment])='Home Office'  THEN [Profit Ratio]*100
END