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 @salmashaikh ,
As SUMX is a iterator function, it is degrading the performance.
Best Regards,LiangIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Check out the on demand sessions that are available now!
Check out the Winners!
Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.