WTD, MTD sales are not showing always and they are changing based on the date slicer.

[reddy421]

Hi,

I have a dashboard where I am displaying the sales of this week, Month and yearly along with the other things based on the Dateslicer.

So this Week, Month and Year sales should be independent on the Dateslicer.

I created new measures for MTD and YTD using the functions available.

But for WTD, I have to create a week number column in week dimension and then create a new measure after that.

Below are the calculations I used.

WeekNum = WEEKNUM(Dim_Date[Calendar_Date],1)

WTD Total = CALCULATE(SUM(v_FactDailySalesWithLowestPriorityRecord[Net Sales USD]),FILTER(Dim_Date,YEAR(Dim_Date[Calendar_Date]) = YEAR(NOW()) && WEEKNUM(NOW())=Dim_Date[WeekNum]))

I am getting the WeelyRev sales sometimes and not always( it is varying based on the data slicer I select)

Good:

Bad:

1) Can you help me in getting the WTD, MTD and YTD sales always?
2) Also Is there a way I can make some part of my dashboard independent on the slicer filters?

Thank you.

[Anonymous]

Yes. You can. use ALL () function to override the Slicer filters.

Thanks

Raj

[reddy421]

Thank you for the reply Rajendran.

I am still getting an error for Monthly and Yearly Revenues If I slice my date to get the sales for next one month or year.

FYI...

I used the below formula for MTD 

MTD = CALCULATE(SUM(v_FactDailySalesWithLowestPriorityRecord[Net Sales USD]),ALL(Dim_Date),DATESMTD(Dim_Date[Calendar_Date]))

or 

MTD Total = TOTALMTD(SUM(v_FactDailySalesWithLowestPriorityRecord[Net Sales USD]),Dim_Date[Calendar_Date])