Thanks for the video. When I import the json onto DAX Studio and I run the Query of a visual on DAX Studio, the ms that I get for that query/visual in Server Timings does not match the Query Ms or Total Ms column from the json. Why? Should not these match? Thanks.
The numbers are more consistent in the exported file as they don't include the "Other". There is an explanation in the documentation (get the .DOCX file): github.com/microsoft/powerbi-desktop-samples/tree/main/Performance%20Analyzer
Not really - every visual shows the total time to render, but the Other time is a waiting time for other visuals. You also have parallelism to take into account. Future videos will show how to export performance data to DAX Studio for a better evaluation.
I am trying to build a multi value parameter paginated report in Power BI. I tried this - EVALUATE SUMMARIZECOLUMNS ( 'Product Category'[Product Category Name], FILTER ( VALUES ( 'Geography'[Country Region Name] ), PATHCONTAINS ( @CountryRegionName, 'Geography'[Country Region Name] ) ), FILTER ( VALUES ('Date'[Fiscal Year] ), PATHCONTAINS ( @FiscalYear, 'Date'[Fiscal Year] ) ), "Internet Total Sales", [Internet Total Sales], "Internet Total Margin", [Internet Total Margin] ) My scenario is little different. I want to filter either on Geography or by date. Meaning - if user enters Geography filter by Geography. If user enters date filter by date. If both are entered filter by all the records of Geography and all the records of date. Outer join. Please help. I tried all the blogs.. No luck yet
![I.N "HALLUCINATION" | [Stray Kids : SKZ-PLAYER]](http://i.ytimg.com/vi/n5B5q1Hwt_U/mqdefault.jpg)
Clear and comprehensive as usual. Bravo!
Great ! Short and to the point. Thank you !
Great tool, You explain it perfectly
Appreciate the way you explained it
appreciate your explanation
excellent explanation sir
Very well explained - Thank you very much
Good presentation, thank you
Great Explanation. Thank you.
Thanks for the video!
Thank you, Sir.
Thanks for the video. When I import the json onto DAX Studio and I run the Query of a visual on DAX Studio, the ms that I get for that query/visual in Server Timings does not match the Query Ms or Total Ms column from the json. Why? Should not these match? Thanks.
The numbers are more consistent in the exported file as they don't include the "Other". There is an explanation in the documentation (get the .DOCX file): github.com/microsoft/powerbi-desktop-samples/tree/main/Performance%20Analyzer
Great Explanation.
Thank you for the video... 👍
If I refresh all the visuals, time shows in the performance analyzer, is it the total time taken by the report?
Not really - every visual shows the total time to render, but the Other time is a waiting time for other visuals. You also have parallelism to take into account. Future videos will show how to export performance data to DAX Studio for a better evaluation.
@@marcorusso7472 Hey Marco thanks for you clear explanation on this topic
,Pls where can i get the next video for better evaluation?
well explained, helps me !!
Sir how we perform load testing on Power BI?
Please make video on difference between Formula engine and Storage engine.
Thank you !
I am trying to build a multi value parameter paginated report in Power BI.
I tried this -
EVALUATE
SUMMARIZECOLUMNS (
'Product Category'[Product Category Name],
FILTER (
VALUES ( 'Geography'[Country Region Name] ),
PATHCONTAINS ( @CountryRegionName, 'Geography'[Country Region Name] )
),
FILTER (
VALUES ('Date'[Fiscal Year] ),
PATHCONTAINS ( @FiscalYear, 'Date'[Fiscal Year] )
),
"Internet Total Sales", [Internet Total Sales],
"Internet Total Margin", [Internet Total Margin]
)
My scenario is little different. I want to filter either on Geography or by date. Meaning - if user enters Geography filter by Geography. If user enters date filter by date. If both are entered filter by all the records of Geography and all the records of date. Outer join. Please help.
I tried all the blogs.. No luck yet
Please post the question in comments of a related article, such as www.sqlbi.com/articles/introducing-summarizecolumns/
Thanks!
Very Good Man Thank you