Create Measure

[Anonymous]

Hi, How can I create a measure to calculate the sum of sales filtered by the Year 2017?  

[amitchandak]

@Anonymous , TRy like

calculate(sum(sales[Amount]), filter(Sales, year(Sales[Date]) = 2017))
or with date table
calculate(sum(sales[Amount]), filter(Date, year(Date[Date]) = 2017))

[Anonymous]

Sales 2017 = CALCULATE(SUM('Revenue Table'[Revenue]),'Date'[Year]=2017) 

That's right?

[vivran22 · Accepted solution]

@Anonymous 

If you add a calendar table/date table in the data model and relate it to with the sales table, then the following formula will work

CALCULATE(SUM(TableName[Sales]), dtCalendar[Year] = 2017)

https://www.vivran.in/post/power-bi-time-intelligence-calendar-table

Cheers!
Vivek

If it helps, please mark it as a solution. Kudos would be a cherry on the top 🙂
If it doesn't, then please share a sample data along with the expected results (preferably an excel file and not an image)

Blog: vivran.in/my-blog
Connect on LinkedIn
Follow on Twitter

[Anonymous]

Thank you for your help