topic Re: Need help with slicer selection dax in DAX Commands and Tips

Need help with slicer selection dax

ajet-p_91 — Wed, 24 Jul 2024 16:32:44 GMT

Hi every one

I have a slicer with the years 2022, 2023, and 2024, and I'm tracking the total price as a key performance indicator (KPI). When I select 2023 in the slicer, I want to see the total price for both 2022 and 2023. Similarly, if I select 2024, I want to see the total price for 2022, 2023, and 2024.

How can I set this up?

and also if i have financial year (2023-24) instead of year how can i do it

Re: Need help with slicer selection dax

Anonymous — Thu, 25 Jul 2024 02:04:32 GMT

Hi ajet-p_91 ,

If only one measure is used, it seems that it is only possible to realize the totals for viewing two years. It could be last year or any span of years. You can check the results below:

Current = CALCULATE(SUM('Date'[Value]),FILTER('Date',YEAR('Date'[Date])=SELECTEDVALUE('Dim Year'[Year]))) Pre = CALCULATE(SUM('Date'[Value]),FILTER('Date',YEAR([Date])=SELECTEDVALUE('Dim Year'[Year])-1))

Hope it helps!

Best regards,
Community Support Team_ Scott Chang

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

Re: Need help with slicer selection dax

ajet-p_91 — Thu, 25 Jul 2024 06:08:34 GMT

Hi Anonymous

It's not working

Re: Need help with slicer selection dax

Anonymous — Thu, 25 Jul 2024 06:26:26 GMT

Hi ajet-p_91 ,

Where are you stuck? What kind of results are you getting?

Best regards,
Community Support Team_ Scott Chang

Re: Need help with slicer selection dax

ajet-p_91 — Thu, 25 Jul 2024 06:30:14 GMT

Hi Anonymous

The current Dax is currently operational, but the pre-Dax is not working. Also, I want data from all previous years, not just last year.

Re: Need help with slicer selection dax

Anonymous — Thu, 25 Jul 2024 06:35:54 GMT

Hi ajet-p_91 ,

Please provide sample data as well as expected results.

Best regards,
Community Support Team_ Scott Chang

Re: Need help with slicer selection dax

ajet-p_91 — Thu, 25 Jul 2024 06:53:30 GMT

Hi Anonymous

This is the result

Current = COALESCE(CALCULATE(SUM('Table'[price]),FILTER('Table','Table'[Year].[Year]=SELECTEDVALUE('Dim Year'[Year]))),0)

Pre = COALESCE(CALCULATE(SUM('Table'[price]),FILTER('Table','Table'[Year].[Year]=SELECTEDVALUE('Dim Year'[Year])-1)),0)

Re: Need help with slicer selection dax

Anonymous — Thu, 25 Jul 2024 07:04:04 GMT

Hi ajet-p_91 ,

Disconnecting dimyear from date seems to work.

An attachment for your reference. Hope it helps!

Best regards,
Community Support Team_ Scott Chang

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

Re: Need help with slicer selection dax

ajet-p_91 — Thu, 25 Jul 2024 07:09:20 GMT

Hi Anonymous

Can you give more details about how to do it

Re: Need help with slicer selection dax

Anonymous — Thu, 25 Jul 2024 07:47:46 GMT

Hi ajet-p_91 ,

Create a year dimension table and use it as a slicer to control the current year versus the previous year that needs to be calculated. Please see the attachment above.

Best regards,
Community Support Team_ Scott Chang

Re: Need help with slicer selection dax

SachinNandanwar — Thu, 25 Jul 2024 17:20:58 GMT

So if I understand your requirements correctly on selecttion of year 2022 the output should be sum of total for year 2022,2023 & 2024. and incase of selection of 2023 the output should be a sum of total for 2023 and 2024.and there can be N number of years following the year that you select.

TotalSum = CALCULATE(SUM('Table'[Value]),'Table'[Date].[Year]>=SELECTEDVALUE('Table'[Date].[Year]))

Re: Need help with slicer selection dax

ajet-p_91 — Fri, 26 Jul 2024 12:12:12 GMT

Hi Anonymous

if we have two slicers like year and month then how can i achieve this

Re: Need help with slicer selection dax

Anonymous — Mon, 29 Jul 2024 01:33:33 GMT

Hi ajet-p_91 ,

This can be accomplished by making simple changes to his expression.

TotalSum = CALCULATE(SUM('Table'[Value]),'Table'[Date].[Year]<=SELECTEDVALUE('Table'[Date].[Year])&&'Table'[Date].[Month]<=SELECTEDVALUE('Table'[Date].[Month]))

Hope it helps!

Best regards,
Community Support Team_ Scott Chang

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