Slicer year selection in to dax measurement

[lancersc]

CP_Price = CALCULATE(SUM(lnz_CORE[Extended Price USD]),

FILTER(lnz_CORE,lnz_CORE[Year Date]= YEAR(Today())))

So in this computation, my boss dwanted that the year would be selectable to any year using a filter.

How can Iink what is being chosen on a slicer to the year filter?

CP_price should be in a specific year

PP_Price should be in a specific year

[AnkitaaMishra · Accepted solution]

Hi @lancersc , 
you can modify your DAX as below : 

CP_Price =
VAR _selectedYear = selectedvalue(Table[year])
VAR _logic = CALCULATE(SUM(lnz_CORE[Extended Price USD]),

FILTER(lnz_CORE,lnz_CORE[Year Date]= _selectedYear))
RETURN
_logic

Please use the year column which you are using in slicer instead of Table[year]

Thanks, 
Ankita

[govind_021]

Hey  
Its simple , extract Year from the Date Column you have in Your Table
Create Calculated column by Following formula
Year = Year ( Pass Date column ) 

Then Select slicer visual from the vizualization and In fields drag  "Year" column
then it will allow the user to filter the data based on the year
make measure simple using Sum( ) formula .
Best Regards
Govind Sapkade
Data Analyst | Power BI Enthusiast | Microsoft PL 300 Certified Power BI Data Analyst | MS Fabric Enthusiast
🎥 Subscribe to my youtube channel for hands on tutorials : YouTube

📊 Let’s connect on Linkdin : Linkdin

[lancersc]

I just added a picture of my first row table.

Unfortunately that won't work

[danextian]

Hi @lancersc 

Your measure should be as simple below as you're simply trying this calculation by the year column from the same table.

SUM(lnz_CORE[Extended Price USD])

[lancersc]

Wont't work on my tables

CP_price should be in a specific year

PP_Price should be in a specific year

[danextian]

Do you mean that whatever year is selected from the slicer, the value for that specific measure won't change? If so, you'll need a slice modification to your formula.

CP_Price =
CALCULATE ( SUM ( lnz_CORE[Extended Price USD] ), lnz_CORE[Year Date] = 2024 )

Otherwise, please provide more context. What do you want to happen when a year from the slicer is selected?

[AnkitaaMishra · Accepted solution]

Hi @lancersc , 
you can modify your DAX as below : 

CP_Price =
VAR _selectedYear = selectedvalue(Table[year])
VAR _logic = CALCULATE(SUM(lnz_CORE[Extended Price USD]),

FILTER(lnz_CORE,lnz_CORE[Year Date]= _selectedYear))
RETURN
_logic

Please use the year column which you are using in slicer instead of Table[year]

Thanks, 
Ankita

[lancersc · Accepted solution]

I did this and a version of this unfortunately it returns blank I wonder why..

edit.

I dont know what I did but I got it working!

I did a combination of yours and this youtube video:
https://www.youtube.com/watch?v=qlBtBme4EL4&t=396s

Thanks!