Forum Discussion

Alex_Hasan's avatar
Alex_Hasan
Icon for Helper II rankHelper II
4 years ago

Dax

Hello good people, I was given the assignment below to solve this. As a newcomer in PBI, I find it confusing. I tried hard and solved the problem, but it seems I actually messed up with the solution....
Alex_Hasan's avatar
Alex_Hasan
Icon for Helper II rankHelper II
4 years ago

Hi amitchandak , what would be the dax for total sales here? Because I need to calculate it properly. 

Is it   SUM(Sales[Net Sales])? 

 

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

Hi   Alex_Hasan , 

 

Did you want sum all the sales until the selected date?

Maybe you can try this measure to do that.

Measure = CALCULATE ( [Total sales], FILTER ( ALLSELECTED ( Dim_Date ), [Date] <= MAX ( 'Dim_Date'[Date] ) ) ) 

 

Best Regards
Community Support Team _ chenwu zhu

 

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