Current year calculation not yielding proper results when I'm are displaying along date hierarchy

[AnandNamburi]

Hi All,

To display CY I have written below DAX, it is working fibe when I'm displaying it alone.

CY Sales = CALCULATE(SUM(Orders[Sales]),FILTER(ALLSELECTED(Orders),Orders[Order Date].[Year]=MAX(Orders[Order Date].[Year])))

But when I'm bring the year column alsong with it, the data is getting group by Year column. Please see below.

I need to display only CY along with 2013, which is not happening in above visualization.

I believe in my DAX calculation I'm using [Year] and thts' why I'm not able to acheive this.

Can anyone fine tune my DAX to get the accurate results along with Year,Quarter,Month.

Thanks,

Anand

[amitchandak · Accepted solution]

@AnandNamburi , Try like

CY Sales =
var _max = MAXX(allselected(Orders) , Orders[Order Date].[Year])
return
CALCULATE(SUM(Orders[Sales]),FILTER(ALLSELECTED(Orders),Orders[Order Date].[Year]=_max))

But prefer to use time intelligence

Power BI — Year on Year with or Without Time Intelligence
https://medium.com/@amitchandak.1978/power-bi-ytd-questions-time-intelligence-1-5-e3174b39f38a
https://www.youtube.com/watch?v=km41KfM_0uA