Question

Hi I am learning Power BI and trying to understand how calculate works without filter calculate sum sales total amout why cant we give sum sales total amount

Comments

Hey @Amitha

Could you please post your workaround what you are trying to do? Do you have any dataset where you want to perform the DAX calculation?

Answer 1

Hello @Amitha,

The CALCULATE function is useful because it can modify the filter context of the Expression inside, as indicated by the n number of filter conditions specified by the user, according to these steps:

• If the filter context specified by a filter condition already exists, it will override the already-existing filter context with the new one that’s been specified in the CALCULATE expression.
• If the filter context does not exist, it will add a new filter context according to the filter condition specified.