scorecards slowing down report

[Anonymous]

I have a report where there are 10 scorecards ( each scorecard is a measure), some with heavy dax looking at a direct connection tabular model

these scorecards takes a long time to load, beause 10 dax queries going behind the scenes

will it be wise to have one matrix visual incorporating these 10 measures ? will that mean when the matrix loads into the report there's only one dax because there's only one visual ( matrix), or even though matrix visual is just one visual, because we have 10 measures inside the matrix its still 10 dax queries interacting with the server ?

other approach would be to spread out the score cards around other pages in the report ? please advise 

[parry2k · Accepted solution]

@Anonymous you are right on, if you are using a matrix visual with 10 measures, it will send one query to the backend whereas using multiple visuals (card visuals) will send seperate queries and will have a performance impact.

✨ Follow us on LinkedIn and  to our YouTube channel

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make effort to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop shop for Power BI-related projects/training/consultancy.