How to show calculations with and without affecting filter? I have data from the past 5 years on college data. I want to show students with multiple filters from different fields such as year, department, etc for pass %, placements, etc and other calculations in the page with and without the filter. May 2, 2019 in Power BI 238 views

## 1 answer to this question.

Hi Praneeth,

Calculate () by default perform calculations that affect filters.

To calculate measures such as avg of students pass %, then you can filter out only pass students and perform calculations.

Use CALCULATE(AVERAGE(Students[Marks %]),Students[Grade]="Pass") to get avg of all students. by applying filter

ALL() avoids all filters applied on the page and perform calculations.

Use CALCULATE(AVERAGE(Students[Marks %]),ALL(Students)) to get the average for all students irrespective of filters applied on the page.

Hope this helps you. answered May 2, 2019 by
• 32,490 points

## DAX Calculate function with and without FILTER

You could make [Measure12] return the same results as ...READ MORE

## Understanding the DAX CALCULATE function

Using the CALCULATE function makes the DAX perform a context ...READ MORE

## 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)?

Hello @Amitha, The CALCULATE function is useful because ...READ MORE

## all and allExcept - DAX functions

Hi Satish, All function is used when you ...READ MORE

## Combine tables in Power BI

You can also achieve this using a ...READ MORE

## Power Bi Dax Table

You need to wrap the numbers in ...READ MORE

## Power BI Dax Multiple IF AND Statements

HI I have Column Patient 12 13 14 15 18 IN Patient=12, 13 Out ...READ MORE

## Distinct count filtered by condition using Power BI Dax

Try this, it should work: DistinctCountActiveMonths = CALCULATE( ...READ MORE