Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Issues with Merged Column

I have a project that is due very soon, and I still can't seem to eliminate this issue, which is impacting many of the visuals in my page. Essentially, the main purpose of this project is to compare ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi Anonymous,

Thanks for reaching out to the Microsoft fabric community forum. It looks like the issue is happening because you’re trying to use a measure ([Total Wdc3]) inside a calculated column. In a calculated column, that measure isn’t getting the same project-level context you see in a visual instead, it’s evaluated row by row at refresh time, which in your case is returning 0 or blank for many rows. That’s why you’re ending up with Infinity or NaN.

You can fix this by skipping the calculated column entirely and doing everything in one measure as already suggested by Sandip_Palit. That way, Power BI will calculate the $/Wdc based on whatever is being shown in your visual (per project, per category, etc.) instead of trying to store a fixed value for every row.

 

I would also take a moment to thank Sandip_Palit and Ritaf1983, for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.

 

If I misunderstand your needs or you still have problems on it, please feel free to let us know.  

Best Regards,
Hammad.

Anonymous's avatar
Anonymous
Not applicable
11 months ago

Hi Anonymous,

As we haven’t heard back from you, so just following up to our previous message. I'd like to confirm if you've successfully resolved this issue or if you need further help.

If yes, you are welcome to share your workaround so that other users can benefit as well.  And if you're still looking for guidance, feel free to give us an update, we’re here for you.

 

Best Regards,

Hammad.

  • Anonymous's avatar
    Anonymous
    Not applicable
    11 months ago

    Hi Anonymous,
    Hope everything’s going smoothly on your end. As we haven’t heard back from you, so I wanted to check if the issue got sorted.
    Still stuck? No worries just drop us a message and we can jump back in on the issue.

     

    Best Regards,

    Hammad.

    • Anonymous's avatar
      Anonymous
      Not applicable
      11 months ago

      Hi Anonymous,
      We noticed there hasn’t been any recent activity on this thread. If you still need support, just drop a reply here and we’ll pick it up from where we left off.

       

      Best Regards,

      Hammad.