Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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) |
Solved! Go to 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.
Proud to be a Super User!
Awesome Keyboard Shortcusts in Power BI, thumbs up if you like the article
My Community Blog Articles (check them out!)
My Blog - Power M code to automatically detect column types -
How to create test data using DAX!
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.
Proud to be a Super User!
Awesome Keyboard Shortcusts in Power BI, thumbs up if you like the article
My Community Blog Articles (check them out!)
My Blog - Power M code to automatically detect column types -
How to create test data using DAX!
Hi @Anonymous ,
You can try these measures.
@harshnathani thank you Harsh for you time. Really appreciate it. Sorry for not provideing more details on the requirement.
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
Hi @Anonymous ,
Can you share your .pbix file removing all sensitive data ?
Regards.
HN
Hi @Anonymous ,
Is budget a column in your table or a measure ?
Regards,
HN
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
43 | |
21 | |
20 | |
15 | |
13 |
User | Count |
---|---|
45 | |
41 | |
39 | |
19 | |
19 |