Topic: SQL Server 2016
New Server Timings features in DAX Studio 2.5.0 #dax #powerbi #ssas #tabular
Last week, a new version of DAX Studio (2.5.0) has been released. You can find a summary of the new features in the blog post from Darren Gosbell – thanks Darren for your wonderful job with this tool! My small contribution to this tool is mainly in the Read more
Leverage INTERSECT to apply relationships in DAX
If you are used to virtual relationships in DAX (see Handling Different Granularities in DAX ), you probably use the following pattern relatively often: [Filtered Measure ] := CALCULATE ( <target_measure>, FILTER Read more
A new MemoryHeapType default in #ssas #tabular 2016 (please, fix your setting in production!)
If you already installed Analysis Services 2016, you should change the MemoryHeapType setting. There is a new default value (-1), which is an automatic choice that currently applies a new hybrid allocator (which has the number 5 as a value). It should Read more