Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
User | Count |
---|---|
54 | |
23 | |
19 | |
18 | |
17 |
User | Count |
---|---|
91 | |
87 | |
47 | |
28 | |
22 |