undefined

[G92749]

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

[v-xinruzhu-msft]

Hi,

Thanks for the solution quantumudit  offered, and i want to offer some more informaiton for user to refer to.

hello @G92749 , 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.

[G92749]

@v-xinruzhu-msft  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.

[v-xinruzhu-msft]

Hi @G92749 

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

[G92749]

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.

[G92749]

@quantumudit did you got a chance to look at it?

[G92749]

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.

[quantumudit · Accepted solution]

Hello @G92749 

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

[G92749]

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.

[G92749]

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.

[quantumudit]

Hello @G92749 

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