Column total not adding to the total sum

[Anonymous]

Hi,

I'm aware this has been asked before, but I was not able to find a solution with the previous quesitons. 
Measure that I'm creating is not adding up to the correct total. 
My measure looks like this: 

Usage Cost = CALCULATE(SUM('Table1'[Total Cost (LCY)]), 'Table1' [Source] <> 1, 'Table2' [Project Type] = 0)

When selecting three ID's I'm getting this output.

ID	USAGE COST
1	512 114
2	220 779
3	235 045
Total	967 938

This should add up to 1,024,285.9 

I have no changed it to an if statement that looks like this, but not working:

Usage Cost = IF(HASONEFILTER('Table'[Job No_]),

CALCULATE(SUM('Table1'[Total Cost (LCY)]),

    'Table'[Source Type] <> 1, Table2[Project Type] = 0),

    CALCULATE(SUM('Table'[Total Price (LCY)]),

    ALLEXCEPT('Table', 'Table'[Source Type])) <> 1)

This is giving me "True" for total, which means my result if false statement needs fixing, but not sure what

How can I fix this? Thanks

THanks

[Icey]

Hi @Anonymous ,

Is this problem solved now?

Best Regards,

Icey

[Anonymous · Accepted solution]

Hi, sorry for late response. Yes, I solved the problem by using the sumarize function I found on this link:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907

[Icey]

Hi @Anonymous ,

Glad to hear that. Please accept your reply as a solution so that people who may have the same question can get the solution directly.

Best Regards,

Icey

[Icey]

Hi @Anonymous ,

If you don't mind, please share me some sample data, not real data.

Best Regards,

Icey

[amitchandak]

Try like

Usage Cost = CALCULATE(SUM('Table1'[Total Cost (LCY)]),values(Table1[ID]), 'Table2' [Project Type] <> 0)

[Anonymous]

Still getting the same total..