topic Re: Find the distinct project sum of budget in DAX Commands and Tips

Find the distinct project sum of budget

Anonymous — Fri, 29 May 2020 07:03:00 GMT

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)

Re: Find the distinct project sum of budget

Anonymous — Fri, 29 May 2020 08:59:40 GMT

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)

Re: Find the distinct project sum of budget

Anonymous — Mon, 01 Jun 2020 04:24:36 GMT

Hi Anonymous

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

Re: Find the distinct project sum of budget

Anonymous — Mon, 01 Jun 2020 04:40:25 GMT

Hi Anonymous ,

Is budget a column in your table or a measure ?

Regards,

Re: Find the distinct project sum of budget

Anonymous — Mon, 01 Jun 2020 04:46:54 GMT

Hi Anonymous ,

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

Regards.

Re: Find the distinct project sum of budget

stevedep — Mon, 01 Jun 2020 05:39:53 GMT

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.

Re: Find the distinct project sum of budget

Anonymous — Mon, 01 Jun 2020 13:26:59 GMT

stevedep thanks you so much Steve. Its working fine.

Re: Find the distinct project sum of budget

Anonymous — Mon, 01 Jun 2020 13:28:54 GMT

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