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.
I feel like I must be missing something simple. I'm looking for a function that keeps the row/column context but ignores any slicers or crossfilters applied. Basically I want the opposite of ALLSELECT, which ignores all the row/column context but obeys any slicers or crossfiltering applied. The reason for this is that I want to create a dynamic calculation that calculates the total for that column/row based on any/all selections divided by the total for that column/row. An example would be calculating the rate of visits for each day of the week and displaying it in a bar graph like this:
a
If no crossfilters/slicers were applied, this graph would show everything at 100%. If a slicer was applied, the slicer would remove the appropriate rows from the numerator but not the denominator. The problem if I use ALL to calcualte the denominator is that it ignores the day context as well as the slicers. I need a table that, when a slicer is applied, looks like this:
Day Numerator Denominator
Sunday 10 50
Monday 20 70
Tuesday 30 40
ALL gives me this:
Day Numerator Denominator
Sunday 10 130
Monday 20 130
Tuesday 30 130
ALLSELECTED gives me:
Day Numerator Denominator
Sunday 10 60
Monday 20 60
Tuesday 30 60
Did you manage to solve this? Im having a similar issue
No, I don't think I did, sorry!
Hi @DataDiva ,
Beside using the allexcept() function, we can also edit the visuals interact letting other slicer not affect current visual: https://docs.microsoft.com/en-us/power-bi/service-reports-visual-interactions
Best Regards,
Teige
Setting the vidualization to not be affected by slicers at all doesn't work, because I need the numerator in my example to be effected by the slicers, but not the denominator.
Did you find any solution for this?
I need to ignore the slicers but keep the rowcontext, im not finding how ALLEXCEPT can help me here.
Have you looked at using ALLEXCEPT?
The problem with allexcept is that it also overrides row/column context, so that doesn't accomplish what I am trying to do.
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 |
---|---|
108 | |
98 | |
81 | |
65 | |
62 |
User | Count |
---|---|
147 | |
116 | |
104 | |
88 | |
65 |