cancel
Showing results for 
Search instead for 
Did you mean: 
Reply

Measure should be untouched by filter

HI All,

 

Here I am asking something entirely opposite.

 

I want to create a measure which should be uneffected by any page level filter or visual filter.

And I should have option to hardcore the filter for only this measure.

 

 

For example, I create a measure which calculate the sum of students. 

Measure 1 = SUM(table[Strength])

 

DepartmentMeasure 1
Physics100
Chemistry200
Math150
English300

 

In power Vi visual: I got a table like this

 

DepartmentStrength
Physics12
Chemistry18
Math20
English14


To get this table I applied the filter on this table. Like class = 9, age is only between 15 to 20.

 

Now I want to get another column which should have the total strength regardless of these condition i.e. class = 9, age is only between 15 to 20. But it should be senstive to slicer because from there I am getting year.

 

Desired output will be something like this:

 

DepartmentStrengthMeasure 1
Physics12100
Chemistry18200
Math20150
English14300

 

So I can calculate the percentage 12/100, 18/200, 20/150...

 

What i am getting now is:

 

DepartmentStrengthMeasure 1
Physics1212
Chemistry1818
Math2020
English1414

 

Hope it is clear.

Please advise, Thanks.

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted

Re: Measure should be untouched by filter

I got the solution by using the function ALLEXCEPT.

Just if anyone has the similar problem.

View solution in original post

1 REPLY 1
Highlighted

Re: Measure should be untouched by filter

I got the solution by using the function ALLEXCEPT.

Just if anyone has the similar problem.

View solution in original post

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

January 2020 Community Highlights

January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!

Top Solution Authors
Top Kudoed Authors