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...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
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?