Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Separate Values in Column Compared to SUM from another Column

Hello all,   I need a help with PowerBI. Measure or a custom column function would work, I prefer a DAX measure.   I need the image without color to look like the one with color. Attached.   Lo...
Need Help
Show and Tell
Tutorial Requests
  • danextian's avatar
    danextian
    Icon for Super User rankSuper User
    3 years ago

    Hi Anonymous ,

     

    I am not sure if it is achievable in Power BI - perhaps a combo of Power Query and DAX is needed. But that aisde, where is volume produced in your data?

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Hi danextian ,

       

      Receipt Qty in Alt.UoM is "volume produced".

       

      I am using "Smash_Fact" Table. This table is the combination of "Albatross" and "ZPOCL". 

      • danextian's avatar
        danextian
        Icon for Super User rankSuper User
        3 years ago

        Hi Anonymous ,

         

        Please also post your data source. My initital assessment requires modifying the table in PQ.