Grand Total Showing Blank Results ( but each line has the correct value)

[Kobe100]

 

Dear Communitity, hope you are doing well.

The code below works at the line item level but when it come to the Grand Total there is not result ( Blannk Grand Total)

Total_Cost per GL =

VAR CurrentGL = SELECTEDVALUE(Report_Structure[Account])

VAR CurrentYear = SELECTEDVALUE(Report_Structure[Fiscal Year])

RETURN

CALCULATE([Total_COST], Transactional[AccountNumber] = CurrentGL, Transactional[FiscalYear] =CurrentYear )

The main: I am using a disconnected table (Report_Structure) to generate measure out of the transactional table.

Thank you in advance

[Kobe100]

Thank you very much. It works perfectly! 

I will review my code to avoid this to happend again!

[Jihwan_Kim · Accepted solution]

Hi,

I am not sure how your semantic model looks like, but please try something like below whether it suits your requirement.

Total_Cost per GL =
VAR CurrentGL =
    VALUES ( Report_Structure[Account] )
VAR CurrentYear =
    VALUES ( Report_Structure[Fiscal Year] )
RETURN
    CALCULATE (
        [Total_COST],
        FILTER (
            Transactional,
            Transactional[AccountNumber]
                IN CurrentGL
                    && Transactional[FiscalYear] IN CurrentYear
        )
    )