Totals for tables

[Anonymous]

Hi Everyone, 

I'm stuck on an issue and I'm guessing my dax needs to be modified, but I am not sure how 😕

I have calculated measures in a table and some show the total and others don't. I would like the total to show for all measures, please see the measures below that are not showing totals, the values show up fine in the table, however for these selected measures below, there is no total available

1. Sales LY ( = VAR CurrentFinPeriod = SELECTEDVALUE('Calendar Table'[Period #])
VAR CurrentFinYear = SELECTEDVALUE('Calendar Table'[ YFiscal Year])
Return
CALCULATE([Sum Sales],
FILTER(ALL('Calendar Table'),

'Calendar Table'[Period #] = CurrentFinPeriod &&
'Calendar Table'[ YFiscal Year] = CurrentFinYear - 1))

2.YOY = IF([Sales LY ]=0,BLANK(),[Sum Sales]-[Sales LY])/([Sales LY])

3.Forecast Sales= IF(ISBLANK([Sum Sales]), CALCULATE([Sum Sales],SAMEPERIODLASTYEAR('Calendar Table'[Date])),BLANK())

Thank you in advance 

Pangea 😉 

[v-piga-msft]

Hi @Anonymous,

For your third formula, you could have a try modify it like below.

Forecast Sales =
IF (
    ISBLANK ( [Sum Sales] ),
    CALCULATE ( [Sum Sales], SAMEPERIODLASTYEAR ( 'Calendar Table'[Date] ) )
)

To get the solution, you 'd better share some data sample could reproduce your scenario and your desired output.

Best Regards,

Cherry