Logic to Bucket Growth Type (Base/Incremental/Attrition)

[jrnewport1115]

Hello,

I currently have three working measures thanks to Matt Allington.

PYsales:=CALCULATE(SUM(revenue[amount]),SAMEPERIODLASTYEAR('Calendar'[Date]))
Growth:=SUM(revenue[amount])-[PYsales]
Type:=IF([PYsales]=0,"Incremental",IF(AND(revenue[Sum of amount]=0,[PYsales]<>0),"Attrition","Base"))

However, for my "Type" logic, I want to be able to place this "measure" into a row or column. I assume this needs to move to a calculated column?

(ie I want to be able to summarize by total base vs. incremental growth)

Any general direction on this one?

Thanks!!

 

[jrnewport1115]

Would still love some help on this one. Looking to store a logic-driven value on a row-by-row basis, by utilizing data from other rows (PY sales at that customer/product level). That way I can place this Calculated Column in a row or column in my pivot table to be able to summarize by total Incremental, Attrition, or Base categories for my growth measure.

Thanks!