Vertipaq compresses the data model in a column-oriented manner, which means that columns with fewer unique values can be easily compressed, but columns with many unique values cannot. You can inspect how much space each column takes up in the model using Vertipaq Analyzer, which is an embedded feature in DAX Studio
Discuss about the question