Totals using a measure

[rmarindti]

I am using a measure to represent either column A (Real) or column B (Escenario) for each month switching over the selected month.  

The representation in the month columns works fine, but the calculated Total is the sum of the whole Column A  (Jan-Dec) instead of the sum of each represented column (Jan - Oct Column A + Nov- Dec Column B)

Is there any way I can achieve the sum of (Jan - Oct Column A + Nov- Dec Column B)

Thank you!

[Jihwan_Kim · Accepted solution]

Hi,

I am not sure how your semantic model looks like, but I tried to create a sample pbix file like below.

Please check the below picture and the attached pbix file.

I hope the below can provide some ideas on how to create a solution for your semantic model.

Expected result measure: =
SUMX (
    VALUES ( 'Calendar'[Year-Month sort] ),
    IF (
        CALCULATE ( MAX ( 'Calendar'[Year-Month sort] ) )
            <= MAX ( 'Slicer calendar'[Year-Month sort] ),
        CALCULATE ( SUM ( Data[Real] ) ),
        CALCULATE ( SUM ( Data[Scenario] ) )
    )
)