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