Power BI Performance Analyzer: time of single positions don't match refresh total time

[Flo1]

Hi,

I am confused by the Performance Analyzer in Power BI Desktop. I have a report with three visuals and hit "Refresh visuals" in the Performance Analyzer. The Total Refresh Time of my Table visual and my column chart (Sales by Month) don't match the sum of the single positions. Why is that?

Performance Analyzer

I am using a composite model. The Slicer uses importet data (the table is storage mode "Dual").

Thanks for your help!

[Anonymous]

Copy the query of bolth the visual and check this on dax studion or simply paste this on notepad. 
you will see how the data is aggregated and group thats the reason why the dax in one visual takes more time than other

[Greg_Deckler · Accepted solution]

@Flo1 Things are happening in parallel or your Direct query is part of your DAX query. So, for the top figures, you take 353+49+50 and get 452. Second set of numbers, 292+21+87 = 400. Math seems to add up for me.

[Flo1]

Hi @Greg_Deckler,

this sounds pretty good to me. I didn't notice that the other three values sum up to the total number in this case. It seems that DirectQuery time is part of DAX-Query time.

Because of your answer I did some research and found this interesting blog article about that:
https://blog.crossjoin.co.uk/2021/05/02/measuring-directquery-performance-in-power-bi/

Thank you for your answer!