Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
hello
I'm trying to create a measure that calculate % from another measures. the idea is a performance measure consists of 5 KPIs with each having a weight percentage
for ex. perfomance measue =
10%*Core achievement
35%*non core achievement
20%* branch sales
15%* average indivisual sales agent achievement
10%* accessories sales
performance measure is then the sum of all the 5 KPI multiplied by their percentage . Each KPI is created in a measure and the final measure will take 5 measures and multiply them by the percentage weight
i created the measure mentioned in the screenshot but once i added it to the visual it's giving the error 'visual has exceeded available resources'. i tried to reduce measures inside the performance measure from 5 to 3 and it worked but i keep it to 4 or 5 measures it gives me again the same error.
how can i get the same result from the this measure without having the error of visual exceeded available resources
the measures i created and added in the performance measure are as below
Use Performance Analyzer. Grab the query for the visual. Examine the query in DAX Studio. Refactor the query.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
45 | |
26 | |
22 | |
13 | |
8 |
User | Count |
---|---|
73 | |
51 | |
45 | |
16 | |
12 |