Dax for multiple inner self joins
Hi guys, I need small help in writing DAX for below situation. table_A id date stagetype statustype 1042268 2020-01-27 1 1 1042268 2020-01-27 3 2 1041658 2020-01-27 2 2 1017296 2020-01-27 3 15 1042269 2020-01-27 1 1 1042270 2020-01-27 1 1 1041053 2020-01-27 3 2 1030893 2020-01-27 2 2 1030893 2020-01-27 3 2 1042271 2020-01-28 1 1 The SQL query is select Count(DISTINCT R.id) AS 'ID' FROM table_A R WITH(nolock) INNER JOIN (SELECT DISTINCT SS.id, Min(SS.date) AS MinDate FROM table_A SS WITH(nolock) WHERE SS.id IN (SELECT SSS.id FROM table_A SSS WITH(nolock) WHERE SSS.stagetype = 5 AND SSS.statustype = 4) AND SS.statustype = 13 AND SS.stagetype = 5 GROUP BY SS.id) AS MinDate ON R.id = MinDate.id AND MinDate.mindate = R.date WHERE R.id IN (SELECT DISTINCT SS.id FROM Table_A SS WITH(nolock) WHERE SS.id IN (SELECT SSS.id FROM Table_A SSS WITH (nolock) WHERE SSS.stagetype = 5 AND SSS.statustype = 4 ) AND SS.statustype = 13 AND SS.stagetype = 5) Actually the query using inner self join. I need DAX for above query. Please help on this.
Select current date as default selection in slicers. (Tabular model - Report Server)
Hello, So I have a 'Year' slicer and a 'Month' slicer, I want my end-users to enter the report with the current Year and Month selected. How to achieve this? I know its possible in Power BI desktop but notice that I am having this problem with Tabular model + Report Server. Thanks in advance, Jim
Server Side Aggregations with POWER BI Report BUilder
Hi, I am trying to create my first report in Power BI Report Builder. I am connecting to our Azure Analysis Services (Tabular) model. The measure "Catchment Rate" is non-additive, i.e. when I display subtotals and use a sum, it will not give me the right results. I understood there is an Aggregate function, but when I use that function the cell remains blank. Is there anyone that can help out? Best, P
Error: Current session is no longer valid due to structural changes in the database
On 29. Aug, I updated my validation environment to the last version of PBI Report Server (Version 1.3.6813.37954 (August 2018)) and also applied the SQL Server 2017 CU10, due to some fixes on SSAS. My Sales model is a SSAS tabular database and it is updated every 10 minutes. Since this last update, I've been facing the following issue in some visuals when I access the reports that consumes my Sales model. The Refresh button on Power BI tend to solve this issue, but it happens again after my model is updated. The error message is "Current session is no longer valid due to structural changes in the database"ยด, but the only action done is a "Process Full" on some tables, and it was working with no errors since the initial release on July 2017. The error seems to choose random visuals: sometimes is a few labels on report, sometimes a table or a slicer... Is someone facing the same issue? Couldn't load the data for this visual Current session is no longer valid due to structural changes in the database. Please try again later or contact support. If you contact support, please provide these details. Request IDbf1a69e8-e350-6bb7-7dc6-a3b9ccb32d3a TimeFri Aug 31 2018 13:30:42 GMT+0200 (Central European Summer Time) Version15.0.2.554
Power bi report server january 2019 - tabular export to execl
Hi I am not able to export to excel from Tabular model , although prommised this feature at this version : And I qoute from Microsoft docs : "Ability to export data to Excel from a tabular visual in the Power BI Report Server so that users can analyze data"Dynamic Row Based Security
I have been following THIS article on how to setup row based security using passed through credentials. I have two identical (duplicates) tables: Employee, and EmployeeSecurity that consist of the following columns: ContactID SupervisorID EmployeeNumber FirstName MiddleName LastName ActiveDirectoryUserName I have a relationship setup between EmployeeSecurity.SupervisorID to Employee.ContactID. I currently have a Role setup on the tabulear model that contains these to tables or dimensions with read access. The Row Filter I am using could probably use some fixing but I'm not sure where: =Employee[SupervisorID]=LOOKUPVALUE(EmployeeSecurity[SupervisorID],EmployeeSecurity[ActiveDirectoryUserName],USERNAME()) I am trying to make it so employees can see their supervisors, and/or supervisors can see their employees. I'm hoping someone sees either what is wrong with my DAX or maybe I'm going about settin up the relationship incorrectly. This is just for functionality practice to prove Dynamic Row Based Security will work for us.
