Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
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
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.