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 still learning and having a terrible time with grouping totals to use for key measures. I am having issues writing a key measure to support a Monthly Total of Story Points so that I can take the below table and calculate the % of stories points by categories for the Month.
In the data below I need to know that for the Month of July BI-Chicago had a total of 93 Story Points for the month, Then show line by line below what that % of points is so that I can take that allocation and associate a cost to it.
Line one would be 3%. Everthing I have tried breaks or isn't grouping correctly.
Solved! Go to Solution.
Hi @Anonymous
Please always show your sample data in text-tabular format in addition to (or instead of) the screen captures. A screen cap doesn't allow people to readily copy the data and run a quick test and thus decreases the likelihood of your question being answered. Just use 'Copy table' in Power BI and paste it here. Or, ideally, share the pbix (beware of confidential data).
Now try this for a new calculate column with the percentage:
ColPerc = VAR Total_ = CALCULATE ( SUM ( Table1[Story Points] ), ALLEXCEPT ( Table1, Table1[Month Year], Table1[Scrum Team Name] ) ) RETURN DIVIDE ( Table1[Story Points], Total_ )
and if you need a column with the total:
ColPerc = VAR Total_ = CALCULATE ( SUM ( Table1[Story Points] ), ALLEXCEPT ( Table1, Table1[Month Year], Table1[Scrum Team Name] ) ) RETURN Total_
Hi,
Create a denominator measure as suggested below
Hi @Anonymous
Please always show your sample data in text-tabular format in addition to (or instead of) the screen captures. A screen cap doesn't allow people to readily copy the data and run a quick test and thus decreases the likelihood of your question being answered. Just use 'Copy table' in Power BI and paste it here. Or, ideally, share the pbix (beware of confidential data).
Now try this for a new calculate column with the percentage:
ColPerc = VAR Total_ = CALCULATE ( SUM ( Table1[Story Points] ), ALLEXCEPT ( Table1, Table1[Month Year], Table1[Scrum Team Name] ) ) RETURN DIVIDE ( Table1[Story Points], Total_ )
and if you need a column with the total:
ColPerc = VAR Total_ = CALCULATE ( SUM ( Table1[Story Points] ), ALLEXCEPT ( Table1, Table1[Month Year], Table1[Scrum Team Name] ) ) RETURN Total_
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 |
---|---|
40 | |
20 | |
19 | |
15 | |
15 |
User | Count |
---|---|
47 | |
28 | |
25 | |
17 | |
17 |