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
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.

v-zhangti's avatar
v-zhangti
Icon for Community Support rankCommunity Support
4 years ago

Hi, samil01 

 

Can you provide some sample data or simple pbix files? Sensitive information can be removed in advance. What kind of expected results do you expect? You can also show it with pictures.

 

Best Regards,

Community Support Team _Charlotte

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