I received this request in many courses, messages and also forum discussions: having an Analysis Services Tabular model, it would be nice being able to extract a correspondent PowerPivot data model. In order of priority, here are the specific feature people (including me) would like to see: Create an empty PowerPivot workbook with the same ...

It was an open discussion - there are several systems in the order of 30-40 GB in production. Compression rate may vary, ranging from hundred millions to billions of rows in the fact tables. Latency is another challenge. Within 1 hour we have many option, but near to 1 minute is a real challenge - at the moment it's just theory on the whiteboard, ...

You need the following calculation:    COUNTROWS (        FILTER (            ADDCOLUMNS (                SUMMARIZE (                    'Internet Sales',         ...

It should something like CALCULATE ( COUNTROWS ( Sales ), Products[color] = "Green" )

You should write this: = CALCULATE ( COUNTROWS ( A ), FILTER ( ALL ( A[key] ), A[key] = B[key] ) )

Jerome: you are right, but since we have a DIFF tool working in text file and we have merge operation working correctly in Visual Studio, this could solve the problem in Tabular and PowerPivot. I am not asking to change the metadata storage for Tabular, I'm asking to define a textual representation of an XML model for humans. The two languages can ...

If you think PowerPivot and Tabular are good tools but sometime the design tools are not fast/complete/flexible enough, please consider voting this suggestion on Connect to request a textual representation Tabular or PowerPivot Data Models. This is the simplest way to improve the Productivity of PowerPivot and Tabular ...

Mostafa, probably this syntax was not available in SQL2005 when I wrote the blog post, and I never updated it - thanks for the comment! Marco

Sorry, but the value in one account cannot be calculated more than once just because the account is owner by more customers! If you waant such a calculation, you have to write another formula, but are you really sure you want that? I never heard anyone with a many-to-many relationship asking for that - which would be easy to do with a JOIN in SQL ...

Prafulla, I'm sorry but I didn't understand what is the issue you have. Can you be more specific? Thanks, Marco