Grouped sum on condition

Anonymous 

Can you try the following measure? You can keep the date and other columns in the visual.

Total = 
CALCULATE(
    SUM(Table[Amount]),
    ALLEXCEPT(Table,Table[Date])
)

________________________

If my answer was helpful, please click Accept it as the solution to help other members find it useful

Click on the Thumbs-Up icon if you like this reply 🙂

Website YouTube  LinkedIn

Hi Anonymous ,

According to your request, you want to use DAX to implement the calculation logic of SQL formula in PBI. I did the following test to sum the value of the Amount column based on the Date.

Best Regards,
Henry

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