Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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])
Department | Measure 1 |
Physics | 100 |
Chemistry | 200 |
Math | 150 |
English | 300 |
In power Vi visual: I got a table like this
Department | Strength |
Physics | 12 |
Chemistry | 18 |
Math | 20 |
English | 14 |
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:
Department | Strength | Measure 1 |
Physics | 12 | 100 |
Chemistry | 18 | 200 |
Math | 20 | 150 |
English | 14 | 300 |
So I can calculate the percentage 12/100, 18/200, 20/150...
What i am getting now is:
Department | Strength | Measure 1 |
Physics | 12 | 12 |
Chemistry | 18 | 18 |
Math | 20 | 20 |
English | 14 | 14 |
Hope it is clear.
Please advise, Thanks.
Solved! Go to Solution.
I got the solution by using the function ALLEXCEPT.
Just if anyone has the similar problem.
I got the solution by using the function ALLEXCEPT.
Just if anyone has the similar problem.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
79 | |
73 | |
56 |
User | Count |
---|---|
145 | |
105 | |
104 | |
90 | |
63 |