Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!View all the Fabric Data Days sessions on demand. View schedule
Hello,
actually I am working on a Pareto Table using visual calculations. I only use two columns from my data model ("Product" and "Sales Volume") and the rest of the columns I try to build as visual calculations in the visual directly to optimize performance.
The calculations are working fine as long as I have less then 500 rows in the visual. When I have 500 or more rows in the visual the calculations of the values "Grand Totel" and "Cumulative Value %" are getting weired. Here are the two calculations that I used to calculate the values:
Cumul Value % =
VAR calculatedValue = DIVIDE([Cumulative Value], COLLAPSEALL([Pareto Value], ROWS))
RETURN FORMAT(calculatedValue, "percent") )
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.