Forum Discussion
How to optimize below DAX
Can take a look at seeing how to perhaps optimize your DAX, but would probably be much more successful if we had a sense of your source data and what you were trying to accomplish. That way we could recreate it and test out some different approaches.
Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Hi Greg_Deckler
I am using the below dax in a measure in analysis service and using this measure in a 'Card with states' visual but while i refresh this report then it takes a lot of time to load so it might be issue with the dax that have been written.
I also posted this one related to it:
https://community.powerbi.com/t5/Service/visuals-are-loading-very-slow-in-power-bi/m-p/522423#M53870
Thanks