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
I can share the data but i can share my problem more elaborately.I have 2 rows in my table lets say for example cash and input.what i want to show in my report in if cash has any value blank then input also doesn't shows up
for example lets have a table like this:
the output table should be:
Hope this make sense what i am trying to say.
Super UserHello 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
Thanks for the solution but it didn't solved my problem , also
this is showing wrong summation calculation . But 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.
I got the solution , i applied filter on the visual "is not blank" on cash and it worked .
Thank you who supported me to find the solution .I always rely on the community for my PowerBI problems and try to help if i can.