Forum Discussion

Anonymous's avatar
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

  • 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

  • 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

  • Anonymous's avatar
    Anonymous
    Not 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.

    • Anonymous's avatar
      Anonymous
      Not 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.

      • Anonymous's avatar
        Anonymous
        Not 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

         

  • Anonymous's avatar
    Anonymous
    Not 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.

     

    • quantumudit's avatar
      quantumudit
      Super 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

      • Anonymous's avatar
        Anonymous
        Not 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.