Forum Discussion
Anonymous
2 years agoNot applicable
Help Needed - DAX
Hi All! I am currently encountering a problem with my dax. Here's the code so far: Contribution to Non-Adoption of Paperless Monthly = VAR AllTransactions = CALCULATE ( SUM ( ...
lbendlin
2 years agoSuper User
see attached
Anonymous
2 years agoNot applicable
Hi! Thank you for the help, it works perfectly. I tried applying this to my visual, and the numbers are correct.
However, when I try to exclude/filter out Segments that return 0 for this measure, the values for the others change. I am assuming it filters out all transactions by these segments as well. Is there a way for me to still include their numbers in the computation?
Here's the visual with the 0 contribution Segments filtered out. Ideally it should be the same numbers for those above, but im able to filter out 0 contribution segments and no numbers change. Thank you!
- lbendlin2 years agoSuper User
when I try to exclude/filter out Segments that return 0 for this measureThen you are modifying the total row count. You need to protect that from your filter.