Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi,
I am trying to get a column giving me the % of total sales per item. I am using a formula using =Divide([sum of sales],([sum of sales],all[list of items]). However if i filter the pivot for some specific item list, it keeps giving me the % of Total and not the filtered set.
Is there a way to have the formula work based on total filtered % ?
Thanks a lot
Solved! Go to Solution.
@Stephane5959
Replace your table names and field names.
Measure =
Divide(
[sum of sales],
CALCULATE(
[sum of sales],
ALLSELECTED([list of items])
)
)
________________________
Did I answer your question? Mark this post as a solution, this will help others!.
Click on the Thumbs-Up icon on the right if you like this reply 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
@Stephane5959
Replace your table names and field names.
Measure =
Divide(
[sum of sales],
CALCULATE(
[sum of sales],
ALLSELECTED([list of items])
)
)
________________________
Did I answer your question? Mark this post as a solution, this will help others!.
Click on the Thumbs-Up icon on the right if you like this reply 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Thank you so much !
User | Count |
---|---|
51 | |
48 | |
20 | |
16 | |
15 |
User | Count |
---|---|
110 | |
45 | |
42 | |
24 | |
20 |