Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Totals for tables

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 ;) 

Need Help

1 Reply

  • v-piga-msft's avatar
    v-piga-msft
    Icon for Resident Rockstar rankResident Rockstar
    8 years ago

    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