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 in Power BI by Praneeth
42 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 by Cherukuri
• 31,840 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 in Power BI by Cherukuri
• 31,840 points
291 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 in Power BI by Cherukuri
• 31,840 points
971 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 in Power BI by anonymous
• 31,840 points
67 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 in Power BI by Avantika
• 1,500 points
527 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,110 points

edited Oct 11, 2018 by Kalgi 219 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
• 42,540 points
107 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 in Power BI by VNK
9,140 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
• 42,540 points
8,981 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 in Power BI by Cherukuri
• 31,840 points
2,153 views
0 votes
1 answer

calculation with condition and filter

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

answered May 2 in Power BI by Cherukuri
• 31,840 points
31 views