Forum Discussion
Help Needed - DAX
Here's a link of Sample Data.
https://docs.google.com/spreadsheets/d/1jal0MBKOjFvIl8JNynqkkAVIr1giZ7Za5Q0okQNPPfQ/edit?usp=sharing
Raw Data
Expected Summarized Data
Hope this helps! Do let me know if you need additional information.
Thank you!
Regards,
see attached
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!
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.