Forum Discussion
undefined
this dax is not showing right output : Adjustedcash = IF(ISBLANK('Fin'[input]),BLANK(),'Fin'[cash]), please help me to make it right
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
10 Replies
- quantumuditSuper User
Hello Anonymous
Please provide more details about the issues you're encountering. You can share a sample of the Power BI report you're working on with anonymized data.
Without sufficient context, it's challenging to determine why you're not receiving the correct output.Thanks,
Udit
- AnonymousNot applicable
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.
- AnonymousNot applicable
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.
- AnonymousNot applicable
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
- AnonymousNot applicable
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.
- quantumuditSuper User
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- AnonymousNot applicable
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.
- AnonymousNot applicable
quantumudit did you got a chance to look at it?