Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hi team, I am very new to Power BI and come across my first question, I have a table where contains the sales amount and team, dates, sample as below:
Agent name | Agent Team | Sales date | Sales total |
Lucy | Team A | 30/07/2020 | 3 |
Marin | Team A | 31/09/2020 | 2 |
Charcy | Team B | 1/08/2020 | 1 |
Chris | Team C | 2/08/2020 | 5 |
I am using Agent team as a slice in Power BI, then I want to calculate the percentage of Sales of each person baes on my selection of teams, for example, if I dont select any team then it will be calculated based on the whole table, the result will be like:
Sales total | Percentage | |
Lucy | 3 | 27.27% |
Marin | 2 | 18.18% |
Charcy | 1 | 9.09% |
Chris | 5 | 45.45% |
but if I select Team A, the percentage will need to calculates based on the total sales of Team A.
Sales total | Percentage | |
Lucy | 3 | 60.00% |
Marin | 2 | 40.00% |
I know we can use the "Percentage of grad total" to show similar results, but I would like to create it as a measure so I can re-use this value.
I tried to use DAX below:
Solved! Go to Solution.
@Anonymous , Try with allselected
Pct Team =
VAR Personal =
sum('table'[Sales Total])
VAR ALLteam=
SUMX(
allselected('table'),
'table'[Sales Total]
)
DIVIDE(Personal, ALLteam)
It worked, thanks 🙂
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
142 | |
77 | |
63 | |
51 | |
47 |
User | Count |
---|---|
214 | |
84 | |
61 | |
61 | |
60 |