Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello everyone i have created Matirx report which Looks like Below :
All the columns are measures with fixed value 0,50 ,100 ... I am maitainng RAG status . where 0 is red 50:Amber and 100 :green
My total is : Total of Column / RAG / Sites(Business Hirachy)
I am using SUMX with Summarization in My DAX which is as below :
Hi @Anonymous ,
As SUMX is a iterator function, it is degrading the performance.
https://powerpivotpro.com/2015/08/nested-sumx-or-dax-query/
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |