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,
Just following up to see if the solution provided was helpful in resolving your issue. Please feel free to let us know if you need any further assistance.
Best regards,
Prasanna Kumar