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.
Hello,
Looking for a bit of help
I am wanting to have the totals and sub totals in each group for the Variance Percentage column as an average.
I have the 4 groups of Site, Account Manager, Customer and then Product.
Underneath product there is each pallet/ batch of stock that we sold but displayed as the date.
So i am needing the totals for each group to do an average rather than a total.
Hi @Ivolution93
Is your problem solved? If you still have question please let me known.
Best Regards
Caiyun Zheng
@Ivolution93 , You need to try a measure like
averageX(values(Table[product]),[Variance Percentage])
you can replace Variance Percentage with its calculation
User | Count |
---|---|
96 | |
90 | |
72 | |
64 | |
58 |
User | Count |
---|---|
148 | |
112 | |
95 | |
81 | |
71 |