Forum Discussion

Anonymous

Not applicable

1 year ago

Solved

undefined

this dax is not showing right output : Adjustedcash = IF(ISBLANK('Fin'[input]),BLANK(),'Fin'[cash]), please help me to make it right

Need Help

quantumudit
1 year ago
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

quantumudit

Super User

1 year ago

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

Anonymous

Not applicable

1 year ago

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.