Column formula wont work with filter on dashboard

[shawnloj]

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 another. It works, but when I try to set a filter, it wont filter with the filter selected. 

I tried using All Selected and Selected value but they are not working with the equation I have. 

I put them at the start of each Var replacing the Calculate, but it wont let me use it because they are all 3 different tables. 

I am trying to see how I can get the dashboard to filter

[v-pgoloju]

Hi @shawnloj,

As we haven’t received any further updates and there are no outstanding queries at the moment, we’ll go ahead and close this thread for now. If you have any additional questions in the future, please don’t hesitate to start a new thread we’re always here to help.

Warm regards,
Prasanna Kumar

[v-pgoloju]

Hi @shawnloj,

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

[v-pgoloju]

Hi @shawnloj,

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

[v-pgoloju · Accepted solution]

Hi @shawnloj,

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]

Did you create a calculated column or a measure? Calculated columns are not aware of slicers selections.

[shawnloj]

good question, it is a column.