Help Needed - DAX

Question

Hi All! I am currently encountering a problem with my dax.&nbsp;&nbsp;Here's the code so far:&nbsp;Contribution&nbsp;to&nbsp;Non-Adoption&nbsp;of&nbsp;Paperless&nbsp;Monthly&nbsp;=VAR&nbsp;AllTransactions&nbsp;=&nbsp;&nbsp;&nbsp;&nbsp;CALCULATE&nbsp;(&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;SUM&nbsp;(&nbsp;'Total&nbsp;Documents'[AllCount]&nbsp;),&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;NOT&nbsp;(&nbsp;ISBLANK&nbsp;(&nbsp;'Total&nbsp;Documents'[Customer&nbsp;#]&nbsp;)&nbsp;),&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;FILTER&nbsp;(&nbsp;'Total&nbsp;Documents',&nbsp;'Total&nbsp;Documents'[Customer&nbsp;#]&nbsp;&gt;&nbsp;50000&nbsp;),&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ALLEXCEPT&nbsp;(&nbsp;'Total&nbsp;Documents',&nbsp;'Date&nbsp;Table'[Reporting&nbsp;MonthYear]&nbsp;),&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ALL&nbsp;(&nbsp;'Total&nbsp;Documents'[Paperless&nbsp;Segment]&nbsp;)&nbsp;&nbsp;&nbsp;&nbsp;)VAR&nbsp;NonAdoptedTransactions&nbsp;=&nbsp;&nbsp;&nbsp;&nbsp;CALCULATE&nbsp;(&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;SUM&nbsp;(&nbsp;'Total&nbsp;Documents'[Unenrolled&nbsp;Document]&nbsp;),&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;NOT&nbsp;(&nbsp;ISBLANK&nbsp;(&nbsp;'Total&nbsp;Documents'[Customer&nbsp;#]&nbsp;)&nbsp;),&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;FILTER&nbsp;(&nbsp;'Total&nbsp;Documents',&nbsp;'Total&nbsp;Documents'[Customer&nbsp;#]&nbsp;&gt;&nbsp;50000&nbsp;)&nbsp;&nbsp;&nbsp;&nbsp;)RETURN&nbsp;&nbsp;&nbsp;&nbsp;AllTransactions//divide(NonAdoptedTransactions,AllTransactions)&nbsp;I'm currently trying to return the 'AllTransactions' in this visual.&nbsp;&nbsp;Ideally, I would want all rows to return 10557 in the Contribution to Non-Adoption Paperless Monthly, but currently it is returning the total amount per segment. I have tried the ALL(Total Documents [Paperless Segment] but it doesnt seem to be working right. Currently thats the only current thing I'm missing. My 'NonAdoptedTransactions' currently work fine.&nbsp;Appreciate any help in this area. Thank you!

lbendlin · Answer

Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). Leave out anything not related to the issue.
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.

https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

anonymous · Answer

Here's a link of Sample Data.https://docs.google.com/spreadsheets/d/1jal0MBKOjFvIl8JNynqkkAVIr1giZ7Za5Q0okQNPPfQ/edit?usp=sharingRaw Data&nbsp;Expected Summarized Data&nbsp;Hope this helps! Do let me know if you need additional information.&nbsp;Thank you!Regards,&nbsp;

lbendlin · Answer

see attached
&nbsp;

anonymous · Answer

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!

lbendlin · Answer

when I try to exclude/filter out Segments that return 0 for this measure
Then you are modifying the total row count.&nbsp; You need to protect that from your filter.

Forum Discussion

Help Needed - DAX

5 Replies

Related content

DAX SOLUTION NEEDED

DAX assistance needed

Need help with DAX Formula

Need Help - DAX Code

need help for dax