Forum Discussion
undefined
Hello Anonymous
Apologies for the delayed reply due to the timezone difference. You can create the DAX measure as follows:
Adjusted Cash = IF(ISBLANK(SUM(SampleTbl[Cash])), BLANK(), SUM(SampleTbl[Input]))Below is the solution screenshot:
Important Consideration:
- Ensure that the "Summarize by" option for the "Cash" column is set to "None" if it hasn't been already.Here's how you can do it:
Best Regards,
Udit
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudo 👍
🚀 Let's Connect: LinkedIn || YouTube || Medium || GitHub
✨ Visit My Linktree: LinkTree
Hi,
Thanks for the solution quantumudit offered, and i want to offer some more informaiton for user to refer to.
hello Anonymous , you can create the following measure.
Measure = CALCULATE(SUM('Fin'[input]),FILTER('Fin','Fin'[cash]<>BLANK()))Output
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous Thank you for your solution but it didn't solved my problem .My main concern it to remove that values where its corresponding cash value is blank.Please have a look at it and share your thoughts and solution.
Hi Anonymous
My solution is to display the value that cash not equal to blank so that the blank cash will be filtered.
Best Regards!
Yolo Zhu
Yes you are right but for me it is showing 38 for all the three column.Anyways it is a very silly of me to not think of filters on the visual .Sometimes the problem is very small and in dire need to resolve it quick i am unable to opt for simple solutions. So i believe problem is on me.