ISfiltered calculations based on year slicer

[refint650]

Hello All

I'm displaying KPI metric(Totalcost)in card visual and is filtered by Year slicers, by default card visual shows total cost for all years.

I also have two measures 

1) Total cost for current financial year(2024 March -2025 april)

2) Total cost for Prior financ year (2023 march -2024 april)

Users want to display current year total cost when no slicers value is selected, else show seleccted year total cost.

how can i achieve this functionality .

Thanks

Rf

[Anonymous · Accepted solution]

Hi @refint650 

Thank you very much dlopesc04 for your prompt reply.

For your question, here is the method I provided:

Here's some dummy data

"Table"

Create a measure.

Total Cost = 
IF(
    ISFILTERED('Table'[Year]),
    CALCULATE(
        SUM('Table'[Cost]),
        'Table'[Year] = MAX('Table'[Year])
    ),
    CALCULATE(
        SUM('Table'[Cost]),
        'Table'[Year] = YEAR(TODAY())
    )
)

Here is the result.

Regards,

Nono Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[dlopesc04]

Try something like this:
Sum_TotalCost =  IF(ISFILTERED('Table'[FiscalYear]), SUM(TotalCost), [YourCurrentYearMeasure])
I'm assuming this year slicer has a relationship to your fact table for the sum to work, let me know if this does the trick.