Forum Discussion

Joseph_Hchaime's avatar
Joseph_Hchaime
Helper III
3 years ago
Solved

Need help with Dax coding

I'm having trouble finding the right syntax to calculate the SUM of the Net Collection column for unique values of the Item Code. Can someone help? I will be using the CALCULATE () function to invoke a userelationship between a date dimension table and a date that's not showing in the sample data below. 

 

 

Need Help
Show and Tell
Tips and Tricks
Tutorial Requests

5 Replies

  • Joseph_Hchaime's avatar
    Joseph_Hchaime
    Helper III
    3 years ago

     This is a more accurate depiction of what I need to achieve. I need to calculate the distinct sum of NetCollection and Net Collection USD for every MatterID/BillID/AllocationDate 

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Hi Joseph_Hchaime ,

       

      Please crate a new measure like:

      Measure = 
SUMX (
    SUMMARIZE (
        'Table',
        'Table'[BillID],
        'Table'[AllocationDate],
        'Table'[NetCollection]
    ),
    'Table'[NetCollection]
)

      Best Regards,
      Gao
      Community Support Team

       

      If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

      How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

      • Joseph_Hchaime's avatar
        Joseph_Hchaime
        Helper III
        3 years ago

        Can I use this number in a detailed table as well with the other columns next to it? or it will mess up the calculation?