Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I am having trouble with the denominator in a division calculation. The denominator is being changed when items in a slicer are selected. I have used REMOVE FILTERS and ALL functions in the measure calculating the denominator, however the denominator value still changes when individual items in the slicer are selected. The only exception is when the "Blank" item in the slicer is selected combined with another slicer option (see below). How do I stop the slicer from changing this measure. ("Edit Interactions" option is not appropriate).
I am calculating the number of Total Tasks with Errors and slicing by the "Error Reason" . "Blank" in the "Error Reason" column represents Tasks that have no errors. "Tasks with Errors " is an number column & "Error Reason" is a text column.
Your help is appreciated.
Measure used:
Reason % =
Var Numerator = CALCULATE(SUM('Worksheet'[TasksWithErrors]))
Var Denominator = CALCULATE(SUM('Worksheet'[TasksWithErrors])), REMOVEFILTERS('Worksheet'[ErrorReason]))
Visuals when Slicer selected
What happens when the "Blanks" are selected in the slicer
Solved! Go to Solution.
Hi,
ALL should work here without problems since you are tring to calculate the total without filters. Here is a working DAX:
Var Denominator = CALCULATE(SUM('Worksheet'[TasksWithErrors])), ALL('Worksheet')
Proud to be a Super User!
Thanks for the help ValtteriN.
It appears that the "Blanks" were not the issue after all. The ALL function worked, however I have a time slicer on the page. I used ALLEXCEPT the Time Slicer in the Denominator Measure and the issue reappeared. I now believe that the Total Tasks is being impacted by the Time slicer which is in-turn modified by the Error Reason, and thus producing incorrect result. I will build a separate Calendar Table and see if this will work.
Hi,
ALL should work here without problems since you are tring to calculate the total without filters. Here is a working DAX:
Var Denominator = CALCULATE(SUM('Worksheet'[TasksWithErrors])), ALL('Worksheet')
Proud to be a Super User!
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
23 | |
8 | |
7 | |
6 | |
6 |
User | Count |
---|---|
28 | |
12 | |
10 | |
10 | |
6 |