Measure calculation based on month slicer

Anonymous , Not clear try like

YTD Sales = CALCULATE(SUM(Table[Amount]),DATESYTD('Date'[Date],"12/31"),Table[Category] ="Sales")

or

YTD Sales = CALCULATE(SUM(Table[Amount]),DATESYTD('Date'[Date],"12/31"),filter(Table,Table[Category] ="Sales"))

 

open items = CALCULATE(Count(Table[Amount]),filter(Table,Table[Category] ="Open Items")) // replace count with sum if needed

 

new measure =divide([open items] * month(max(Table[Posting Date]) )* 30 ,[YTD Sales ])

 

 

Power BI — YTD
https://medium.com/@amitchandak.1978/power-bi-ytd-questions-time-intelligence-1-5-e3174b39f38a

 

To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :
https://radacad.com/creating-calendar-table-in-power-bi-using-dax-functions
https://www.archerpoint.com/blog/Posts/creating-date-table-power-bi
https://www.sqlbi.com/articles/creating-a-simple-date-table-in-dax/

See if my webinar on Time Intelligence can help: https://community.powerbi.com/t5/Webinars-and-Video-Gallery/PowerBI-Time-Intelligence-Calendar-WTD-YTD-LYTD-Week-Over-Week/m-p/1051626#M184


Appreciate your Kudos.

 

or Averagex(Values(Table[Month],divide([open items] * month(max(Table[Posting Date]) )* 30 ,[YTD Sales ]))

 

Hi Anonymous ,

 

Do you want to calculate the Total open item in selected month / YTD sales.

For example, we select Jan, it will calculate the Total open item in Jan and the Total * 1 * 30, then the vaule / sales in Jan.

Based on your sample data, it will be (340 + 500 + 670 + 800 +920) * 1 *30 / (100 + 200 + 300 +400 + 100 + 200 + 300)

 

 

If yes, we can create two measures to meet your requirement.

 

YTD Sales = 
CALCULATE(SUM('Table'[ Amount in local currency ]),FILTER(ALL('Table'),'Table'[Category]="Sales"&&'Table'[Month]<=MAX('Table'[Month])))

 

Result = 
var _select = SELECTEDVALUE('Table'[Month name],"Jan")
var _select_month = CALCULATE(MAX('Table'[Month]),FILTER('Table','Table'[Month name]=_select))
var _Open = CALCULATE(SUM('Table'[ Amount in local currency ]),FILTER('Table','Table'[Category]="Open items")) * _select_month * 30
return
DIVIDE(_Open,[YTD Sales])

 

And put it in a table visual, the result like this.

 

 

 

If it doesn’t meet your requirement, could you please show the exact expected result based on the table that you have shared?

 

Best regards,

 

Community Support Team _ zhenbw

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

 

BTW, pbix as attached.