Forum Discussion
Calculation Group - Calculation Item Measure Help
Hello Community - I am in need of some help writing a calculation item within my calculation group. I currently have a calc group with 4 items in it and then it is pulled into a matrix against som...
ryan_b_fiting , I think, very similar to YOY.
example
Lines Up =
VAR _CY = selectedmeasure()
VAR _LY = calculate ( selectedmeasure(), sameperiodlastyear(Date_Table[Date]))
VAR _YoY = _CY - _LY
CALCULATE(
COUNTROWS( SUMMARIZE('Master_Tbl','Master_Tbl'[Customer])),
FILTER( SUMMARIZE('Master_Tbl','Master_Tbl'[Customer] ), _YoY > 0 )
)
amitchandak thanks for the reply. I have already tried that, but that does not work. That gives me the same value across all base measures, and it does not allow me the 'BLANK' value measures that I do not want to see YoY count for (only want to see it for Sales, Lines, GP1)