Using percentage of a whole to calculate a bill

[BMac-Coop]

I'm not quite sure how to do this, but I'd think I could do this with a Measure.

I have a fixed cost of $100,000.  I have many projects...each uses a different percentage of the total capacity every month (as measured by story points).  I have a simple table visualization that sumarizes this:

Month 1:

Project	Number of points	Percent of total
A	10	10%
B	20	20%
C	30	30%
D	40	40%

That visualization is made up of a dataset containing Agile Stories:

Project	Story ID	Story Points
A	123	3
A	124	4
A	125	2
A	126	1

The table visualiztion is very simple.  Don't summarize Project, Sum Story Points, and Sum Story Points shown as percentage of grand total.

In the table visualization (that shows a total of points by project and the percent of total points it made up), I'd like to add a column that takes the percentage consumed and calculates a consumption cost based on my fixed cost.  ie, 40% of the $100,000 fixed cost is $40,000.

In psudo code, effectively:

(sum of rows for project / sum of all rows) * 100000

But I can't wrap my head around how to write the DAX filter to take in the "Project A Sum of Rows" thing.  This seems simple, but I can't figure it out.  Any help would be greatly appriciated!

Thanks!

EDIT:

Let me include a few more details on something I've tried and some details of my challenge.

• The dataset contains many months of data.  On the visualization I have it limited to a specific date range.
• I've tried using ALL, but this removes the date filter as well as the filter for the context of the row.  Where I need to keep the DATE filter but loose the context filter of the particular visualization row.  This DAX is giving me the portion of this months points for this project compared to all months of all projects.  I need this month's portion of points for the project against this months point total:
  • Point Portion = DIVIDE(SUMX('Arrow & Yukon - Stories (Current)','Arrow & Yukon - Stories (Current)'[Story Points default to 1]) , SUMX(ALL('Arrow & Yukon - Stories (Current)'),'Arrow & Yukon - Stories (Current)'[Story Points default to 1]))

[v-yiruan-msft · Accepted solution]

Hi @BMac-Coop ,

I created a sample pbix file(see attachment) for you, please check whether that is what you want. You can create a measure as below:

If the above one can't help you get the desired result, please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.

How to upload PBI in Community

Best Regards

[BMac-Coop]

I ended up doing it a bit differently, but I think the same result:

Cost Per Project = 
DIVIDE(
	SUMX('Table','Table'[Story Points default to 1]),
	CALCULATE(
		SUM('Table'[Story Points default to 1]),ALL('Table'[CT Number])
		)
	) * 100000

Thanks for the ideas that got me going!

[lbendlin]

Please provide sanitized sample data that fully covers your issue. If you paste the data into a table in your post or use one of the file services it will be easier to assist you. Avoid posting screenshots of your source data if possible.

Please show the expected outcome based on the sample data you provided. Screenshots of the expected outcome are ok.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523