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
danextian
Super User
Super UserDid you create a calculated column or a measure? Calculated columns are not aware of slicers selections.
good question, it is a column.