Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi All
I need help creating a measure for an average of a measure which calculates proportions at a siteid level.
Currently I have the above table which calculates proportions for each site, product and crossshopproduct.
I now want a measure for a different table which can average all of the different sites' %'s grouped by product name and crossshopproduct.
This is my currrent measure to find the proportions, very simple as the table does the filtering.
Hi @jeevan_j97
Thanks for reaching out to us.
Could you please share some sample data and its expected outcome?
For this example image, I can't see what your raw data looks like and how I need to calculate this data (calculation formula) and its correct result, so that I can check whether my measure is correct according to your expected output.
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
91 | |
73 | |
68 | |
63 | |
55 |
User | Count |
---|---|
98 | |
89 | |
73 | |
63 | |
61 |