Advertisements I have a static dimension to create in SSAS tabular model and without creating it in the datawarehouse which is populating the cube, the dimension is like below : Status StatusID In 1 Out 2 In (Exit Confirmed) 3 How can achieve that ? >Solution : You can easily use SELECTCOLUMNS() function in DAX… Read More Create a static table in a tabular model

Advertisements I have an SSAS Tabular model composed of a fact table and 3 dimensions. I want to understand what is the difference between creating the relationships in the tabular model in advance comparing to import the tables or using a direct query and then create the relationships in Power BI ? >Solution : If… Read More Creating relationships in an SSAS Tabular model vs Power BI

Advertisements Is there any wa to get the debug of the created DAX final formulas in a tabular model? >Solution : SQL Server Profiler is the most recommended tool for debugging DAX queries. For more information, please refer to the links below : http://mdxdax.blogspot.com/2011/12/dax-query-plan-part-1-introduction.html http://www.sqlbi.com/wp-content/uploads/DAX-Query-Plans.pdf