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
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
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.
