Forum Discussion
Column formula wont work with filter on dashboard
Hi, I have 3 seperate tables that are all set with relationships. I then added them into a dashboard. I created a Dax formula that allowed me to subract from one table column to anot...
Hi Anonymous,
Thank you for reaching out to the Microsoft Fabric Forum Community.
If you want your slicers (like the "PartTime / FullTime" filter) to actually affect your numbers, then don't use ALL() unless it's really needed. ALL() ignores slicers that’s why your filter doesn’t work. Try using below dax to get the desired result.
Diff =
VAR Staffed = COUNTROWS('HR Data')
VAR Budgeted = SUM(ind'[Budget])
VAR Recruiting1 = COUNTROWS(Recruiting)
RETURN
(Staffed + Recruiting1) - Budgeted
Kind regards,
Prasanna Kumar
Hi Anonymous,
We wanted to kindly check in to see if everything is working as expected after trying the suggested solution. If there’s anything else we can assist with, please don’t hesitate to ask.
Warm regards,
Prasanna Kumar