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
11 views

1 answer to this question.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
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
• 13,940 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
• 13,940 points
16 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
• 13,940 points
12 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
• 13,940 points
10 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 6 days ago in Power BI by Avantika
• 1,220 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,100 points

edited Oct 11, 2018 by Kalgi 85 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
• 35,880 points
42 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 4 days ago in Power BI by VNK
3,737 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
• 35,880 points
2,111 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
• 13,940 points
147 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
• 13,940 points
13 views

© 2018 Brain4ce Education Solutions Pvt. Ltd. All rights Reserved.
"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.