Forum Discussion

Mjolnir's avatar
Mjolnir
Icon for Helper I rankHelper I
2 years ago
Solved

Not working: sum based on selected slicer values and additional criterias

Hi,   Want to create a measure to sum previous year's values. Previous year should be equal to selected year in slicer subtracted by 1. Years, months and days are numbers formatted as text in my da...
  • Mjolnir's avatar
    Mjolnir
    2 years ago

    Thanks for your response mate.

     

    The following DAX solved the issue:

    CALCULATE(

        SUM(facts_general_ledger[values]]),

        FILTER(

            ALL(dim_calendar),

            VALUE(dim_calendar[year]=SELECTEDVALUE(dim_calendar[year])-1

        )

    )


Mjolnir's avatar
Mjolnir
Icon for Helper I rankHelper I
2 years ago

Thanks for your response mate.

 

The following DAX solved the issue:

CALCULATE(

    SUM(facts_general_ledger[values]]),

    FILTER(

        ALL(dim_calendar),

        VALUE(dim_calendar[year]=SELECTEDVALUE(dim_calendar[year])-1

    )

)