Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Find articles, guides, information and community news

Most Recent
Super User
Super User

The article delves into the functionality of the CALCULATE filter in DAX, focusing on how it can be utilized to override existing filters for precise data computation in a sales table scenario. It guides through a process of calculating Profit and Profit percentages, facing issues when external filters are applied. It explores solutions by employing DAX functions like ALL, ALLEXCEPT, and ALLSELECTED to manipulate filter context, ensuring accurate calculations while accommodating external filters.

Screenshot 2023-11-03 at 11.21.32.png


Helpful resources

Join Blog
Interested in blogging for the community? Let us know.