Hi everyone,
I am using the below measures:
Sum of Amount - Actuals = CALCULATE( SUM(SUN[Amount]) , SUN[Ledger] = "A" )
YTD Actuals = IF( HASONEVALUE( 'Calendar'[Financial Year] ) , TOTALYTD( [Sum of Amount - Actuals] , 'Calendar'[Date] , "30/06" ) , 0 )
Pretty standard stuff.
However, I get some unusual behaviour when drilling through charts.
Our structure goes Department > Cost Centre. Everything is as expected at Department level, but when I drill to Cost Centre level some values are missing. Upon investigation the missing values are those that do not have a value in the month selected by slicer. But for those that do have a value in the current month, the values are summing correctly for the YTD.
If I select all months up to and inc. current month the problem is fixed, but this is not how I would like people to use the report.
Any ideas? Do I need to change my YTD measure to include FILTER(ALL(Dates ... ?
Thanks
Rich
I am using the below measures:
Sum of Amount - Actuals = CALCULATE( SUM(SUN[Amount]) , SUN[Ledger] = "A" )
YTD Actuals = IF( HASONEVALUE( 'Calendar'[Financial Year] ) , TOTALYTD( [Sum of Amount - Actuals] , 'Calendar'[Date] , "30/06" ) , 0 )
Pretty standard stuff.
However, I get some unusual behaviour when drilling through charts.
Our structure goes Department > Cost Centre. Everything is as expected at Department level, but when I drill to Cost Centre level some values are missing. Upon investigation the missing values are those that do not have a value in the month selected by slicer. But for those that do have a value in the current month, the values are summing correctly for the YTD.
If I select all months up to and inc. current month the problem is fixed, but this is not how I would like people to use the report.
Any ideas? Do I need to change my YTD measure to include FILTER(ALL(Dates ... ?
Thanks
Rich