Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers!
Enter the sweepstakes now!See when key Fabric features will launch and what’s already live, all in one place and always up to date. Explore the new Fabric roadmap
So I have this matrix table like this. Let's look at Jul 22.
When it is collapsed, the Monthly On Time Completion % is Incorrect. It is supposed to be: 78/85 =91.7%.
So why does it show 71.7%? because when I expand it, it is the Avg of the individual rows: 90+25+100/3
So my question is, when I collapse it, how can I force it to show 91.7% , intead of 71.7% (as in the first picture)
What measures are you using?
Proud to be a Super User!
Paul on Linkedin.
no measure, it's just data from an imported table
User | Count |
---|---|
88 | |
74 | |
69 | |
59 | |
56 |
User | Count |
---|---|
40 | |
38 | |
34 | |
32 | |
28 |