Find the distinct project sum of budget

[Anonymous]

I am looking to find the sum of the budget of disticnt project .  Really appreciate if someone can help me on this

Project name	status	budget	datesk
Project A	dev	6500	20200528
Project B	in progress	5000	20200528
Project C	QA	5500	20200528
Project A	completed	6500	20200529
Project B	Unit testing	5000	20200529
Project C	Complted	5500	20200529

expected result : 

Budget of project

17000 (6500+5000+5500)

[stevedep · Accepted solution]

Hi,

Here is the solution for you:

sumdistinct = 
var tbl = SUMMARIZE('Table';'Table'[Name];'Table'[Project];'Table'[Budget])
return
SUMx(tbl;'Table'[Budget])

As can be seen here:

 

Power BI file is available here. 

Please mark as solution if this is what you are looking for. Thanks!

Kind regards,

Steve. 

[Anonymous]

@stevedep  thanks you so much Steve. Its working fine. 

[harshnathani]

Hi @Anonymous ,

You can try these measures.

BudgetT = MAX('Table'[budget])

Project Budget = SUMx(DISTINCT('Table'[Project name]),[BudgetT])

Regards,

Harsh Nathani

Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

[Anonymous]

@harshnathani  thank you Harsh for you time. Really appreciate it. Sorry for not provideing more details on the requirement. 

[Anonymous]

Hi @harshnathani 

when i create this measure BudgetT = MAX('Table'[budget]) getting an error "The MAX funtion only accept a column reference as the argument number 1". 

Then i tried to change it by BudgetT = MAX('Table'[budget],1) , this measure error got fixed but the final measure getting as below

project budget: 6500212

Could you please help me 

[harshnathani]

Hi @Anonymous ,

Can you share your .pbix file removing all sensitive data ?

Regards.

HN

[harshnathani]

Hi @Anonymous ,

Is budget a column in your table or a measure ?

Regards,

HN