Need help with Dax coding

[Joseph_Hchaime]

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. 

[Anonymous · Accepted solution]

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]

 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 · Accepted solution]

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]

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?

[Anonymous · Accepted solution]

Hi @Joseph_Hchaime ,

Could you please provide an simple file and a screenshot of the expected output? This is gonna help.

How to provide sample data in the Power BI Forum - Microsoft Fabric Community

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

[amitchandak]

@Joseph_Hchaime , Try a new measure like

Sumx(summarize(Table, Table[Item Code], Table[New Collection]), [New collection])