Calculate and filter function - DAX

0 votes
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 by Praneeth
261 views

1 answer to this question.

0 votes
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 Cherukuri
• 32,490 points

Related Questions In Power BI

0 votes
1 answer

DAX Calculate function with and without FILTER

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

answered Sep 24 in Power BI by Gitika
• 42,520 points
59 views
0 votes
1 answer

Understanding the DAX CALCULATE function

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

answered Sep 28 in Power BI by Gitika
• 42,520 points
42 views
0 votes
1 answer

How DAX Difference between naked SUM and sum wrapped in CALCULATE?

This is materially different than the question ...READ MORE

answered Oct 8 in Power BI by Gitika
• 42,520 points
17 views
+3 votes
2 answers

Combine tables in Power BI

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

answered Oct 5, 2018 in Power BI by lina
• 8,220 points

edited Oct 11, 2018 by Kalgi 670 views
0 votes
1 answer

Power Bi Dax Table

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

answered Oct 5, 2018 in Power BI by Kalgi
• 51,970 points
265 views
0 votes
2 answers

Power BI Dax Multiple IF AND Statements

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

answered May 22, 2019 in Power BI by VNK
15,472 views
0 votes
1 answer

Distinct count filtered by condition using Power BI Dax

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

answered Oct 5, 2018 in Power BI by Kalgi
• 51,970 points
23,793 views
0 votes
1 answer

How to calculate cumulative Total and % in DAX?

Hi, If your table is ready with percentage ...READ MORE

answered Mar 18, 2019 in Power BI by Cherukuri
• 32,490 points
9,330 views
0 votes
1 answer

calculation with condition and filter

Hi Preethi, Follow the below steps: 1. Create a ...READ MORE

answered May 2, 2019 in Power BI by Cherukuri
• 32,490 points
74 views