How to calculate with different slicer value

[TKhanca]

Hello,

I have two measures on the card visual with filter table1[Year]. First measure is fine and filtering counts based on the selection from the slicer. How can I calculate counts for a diffrent year when table1[Year] is selected. (e,g table1[Year]-3).

 Relationship Year[table1] = Year[table2]

Thank you.

[v-xinc-msft]

Hi @TKhanca ,

Could you please provide sample files or sample files here? We could offer you more help if we have information in detail. And what you expect the output to be. There is sensitive data that can be removed in advance. How to provide sample data in the Power BI Forum - Microsoft Fabric Community

Thanks for your understanding. Your time and cooperation are much valued by us. We are looking forward to hearing from you to assist further.

Best regards,

Lucy Chen

[Bibiano_Geraldo]

Hi @TKhanca ,

You can create a measure like this:

CountForYearMinus3 = 
VAR SelectedYear = MAX('table1'[Year]) -- Get the selected year
VAR TargetYear = SelectedYear - 3 -- Calculate the target year
RETURN
    CALCULATE(
        COUNT('table2'[SomeColumn]), -- Replace 'SomeColumn' with the column you're counting
        FILTER(
            ALL('table1'), -- Remove current slicer filter from table1
            'table1'[Year] = TargetYear
        )
    )

If the slicer filters table1[Year] to 2024:

• SelectedYear will be 2024.
• TargetYear will be 2021.
• The measure will count rows in table2 where the year is 2021.

[TKhanca]

Thank you very much Bibiano for your help. It worked for Card but I have another Table visual where I need to use this measure with other columns but it always display the same value.

[Bibiano_Geraldo]

Can you show me a picture of your table visual?

[TKhanca · Accepted solution]

@Bibiano_Geraldo , thank you very much for your help.

REMOVEFILTERS(Term[Term_Code]) worked to solve this scenario.