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,
In the measure 'AR total avg', I use 2 variables, 'ar_source' and 'agent_validate'
At lowest level of the hierarchy, variable 'ar_source' shows total leads of each source.
On the next level of the hierarchy, variable 'agent_validate' shows the sum of total leads of all sources.
However, variable 'agent_validate' shows 54893 leads which is incorrect, the correct number is 96512 (sum of total leads of all sources calculated by variable 'ar_source')
Please help me with this case :(.
Solved! Go to Solution.
You should never perform any calculations in SUMMARIZE in measures. SUMMARIZE is such a complex function (in terms of behaviour) that Alberto Ferrari and Marco Russo strongly advise against performing calculations within it (they themselves never do it). Please, instead use the combination ADDCOLUMNS/SUMMARIZE. SUMMARIZE must only be used for grouping, nothing else, if you want to stay sane.
Hi mate,
Thanks for your advice, do you have any idea how I can apply ADDCOLUMNS with this case?
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 |
---|---|
47 | |
23 | |
20 | |
15 | |
13 |
User | Count |
---|---|
51 | |
42 | |
39 | |
19 | |
19 |