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
88 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,440 points

Related Questions In Power BI

0 votes
1 answer

all and allExcept - DAX functions

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

answered May 7, 2019 in Power BI by Cherukuri
• 32,440 points
650 views
0 votes
1 answer

Difference between measure and calculate column in power BI

Hi Rahul,  With calculated columns, you can add new ...READ MORE

answered May 16, 2019 in Power BI by Cherukuri
• 32,440 points
2,664 views
0 votes
1 answer

Calculate age from dob field and another date value using slicer

Hi Karthick, Create a parameter with year range ...READ MORE

answered May 17, 2019 in Power BI by anonymous
• 32,440 points
185 views
0 votes
1 answer

How do I calculate difference between consecutive rows and columns?

There are two ways through which you ...READ MORE

answered May 20, 2019 in Power BI by Avantika
• 1,500 points
2,672 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,200 points

edited Oct 11, 2018 by Kalgi 368 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,830 points
176 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
12,211 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,830 points
14,690 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,440 points
4,899 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,440 points
47 views