Drillthrough on the referenced id in a column table
Hi everybody If a referenced project ID exists in the table, I want to drillthrough on the referenced project id (in a second report page). Expected result: In the report page 2 I want to see the information of the referenced project and not of the original project (row 1 in the table in report page 1). Current Status: I used the filter 'Referenced project ID' for all visuals in report page 2. But I still get the information of the original project instead of the referenced project. I believe I have to match 'project ID' and 'Referenced project ID'? Thank you in advace for your support. Greetings
Nested dynamic queries, easy in SQL - difficult in PowerBI/DAX
Assume a single large source table, which must be queried in two steps: Tab1: Key_A Key_B Key_C Val a1 b1 c2 1 a1 b2 c1 5 a2 b3 c1 3 a2 b4 c2 8 a2 b4 c1 1 a2 b1 c2 4 With a variable drillvar = "a2" and two queries you would get: Qry1: SELECT Key_B , Sum(Val) AS SumVal FROM Tab1 WHERE Key_C = 'c1' AND Key_A = drillvar GROUP BY Key_B Qry2: SELECT Key_B , Sum(Val) AS SumVal FROM Tab1 WHERE Key_C = 'c2' AND Key_A = drillvar GROUP BY Key_B Key_B SumVal b3 3 b4 1 Key_B SumVal b1 4 b4 8 In the next step, both queries would be joined (the "Nz" function is used here to handle null/blank values): Qry3: SELECT Qry1.Key_B, Nz(SumVal1) - Nz(SumVal2) AS Diff FROM Qry1 LEFT JOIN Qry2 ON Qry1.Key_B=Qry2.Key_B Result: Key_B Diff b3 3 b4 -7 The task seems trivial. I think in PowerBI with DAX plus a Drillthrough value instead of SQL plus a variable it should be easy to do. Unfortunately, I've been racking my brains for two days on how to solve this efficiently, i.e. especially with a large source table. Does anyone here have an idea?
SSAS Tabular - Default Detail Rows Expression
For a SSAS 2017 tabular model surfaced via pivot tables, a handy (vital) feature is the ability to drill through to a sensible selection of detail rows via double click on a measure (just like in the old school Excel pivot tables that your finance department can't part with). The content of the drillthough is determined by the table property [Default Detail Rows Expression]. The example Microsoft provides here is great insofar as it goes. SELECTCOLUMNS( 'Internet Sales', "Customer First Name", RELATED( Customer[Last Name]), "Customer Last Name", RELATED( Customer[First Name]), "Order Date", 'Internet Sales'[Order Date], "Internet Total Sales", [Internet Total Sales] ) My problem is that I have a calendar table with an active relationship with my fact table (let's call this fact column end_date_sk) and an inactive relationship with the same table (let's call this fact column start_date_sk). If I want to return calendar columns from both the inactive and active relationships, what do I do? RELATED() only seems to work for the active relationship.
SSRS Drill Through issue
Hi I have created two reports and the source of reports are SSAS 2016(Multidimensional Cube): -> MainReport -> DrillDownReport In the Main report i have 3 SelectLists based on Market Dimesion: Level 1: Region -> Burgenland, Salzburg, Niederösterreich, Tirol.... Level 2: District (filter based on Region. e.g Burgenland) -> Mattersburg, Rust (Stadt) .... Level 5: Customer -> 12345_xyz, 65432_abc, 99999_qwe I have configured the drillthrough in the MainReport and passing the selecteditem (Region or District or Customer) as a parameter. The drillthrough works fine untill and unless the selectedItem is without any special character (Umlaut, whitespace, "(", underscore etc) I am getting the following error message if i select "Niederösterreich" OR "Rust (Stadt)" OR "99999_LastName" OR "Neusiedl am See": "The mobile report could not be loaded. The report may be incorrectly configured, data is unavailable, or the server version may not be supported." Has anyone encountered with similar error? Thanks!! Neena
