Forum Discussion

samil01's avatar
samil01
Frequent Visitor
4 years ago

How To Sum Without Being Affected By Date Slicer

I want to sum my data measure without affected date slicer. When i use the this dax,   Sales = CALCULATE(SUM(FactSales[total_price]),FILTER(FactSales,FactSales[datetime] <=DimComprePeriod[End Comp...
Need Help
Tips and Tricks
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

samil01 , On have a separate date table joined with the date of your fact

 

Sales = CALCULATE(SUM(FactSales[total_price]),FILTER(All(Date),Date[datetime] <=[End Compare Period] && Date[datetime] >= [Start Compare Period]))

 

Independent date table

Need of an Independent Date Table:https://www.youtube.com/watch?v=44fGGmg9fHI

 

samil01's avatar
samil01
Frequent Visitor
4 years ago

amitchandakfirst of all thank you for your answer,

 

I have already a date table but i want to sum totals by hour. For example i want to sum from beginning of the yesterday to until which hour are we in right now, e.g for now i want to sum 2022-05-22 00:00:00 - 2022-05-22 11:00:00 so i need datetime field.