Forum Discussion
Solved
DAX Filter Context
Hi, I have a measure called _TotalUnits which works great. What I want to do is to work out the sum of DepreciationMonth from another table where the _TotalUnits > 0. The difficulty is t...
Yes, your formula is probably correct. Since I couldn't see your data I wasn't sure if there was another field that should be there.
HASONEVALUE - To answer your question, I believe the the HASONEVALUE is the true/false condition that tells it when to use which behavior, so at the row level it will use the first part because it is at the row level and therefore 'has one value'.
VALUES - For the Values function, this just creates a summary table with one column for the SUMX function to use.
So I don't know why this isn't working:
OnHire DepreciationMonth
1
0
0
0