Daily DAX : Day 15 INFO.DICTIONARYSTORAGES

This is another DAX function that  is based on the Data Model View tables. 


Returns a table that gives an indication of the storage being used

Example

Let’s say you’re working on a Power BI model for a retail company, analyzing their sales data. You want to understand which dictionary storages are using a significant amount of space in your model. Here’s a DAX query using INFO.DICTIONARYSTORAGES to identify dictionary storages with sizes greater than 1MB


EVALUATE

FILTER(

    INFO.DICTIONARYSTORAGES(),

    INFO.DICTIONARYSTORAGES[Size] > 1048576

)


The example output would  have the following fields :


  • ID: Unique identifier for each dictionary storage.
  • ColumnStorageID: Identifier for the associated column storage.
  • Type: Indicates the type of storage (e.g., Text, Integer).
  • DataType: Data type of the dictionary storage.
  • DataVersion: Version of the data.
  • BaseId: Base identifier.
  • Magnitude: Magnitude of the storage.
  • LastId: Last identifier used.
  • IsNullable: Indicates if the storage can contain null values.
  • IsUnique: Indicates if the storage values are unique.
  • IsOperatingOn32: Indicates if the storage operates on 32-bit.
  • DictionaryFlags: Flags related to the storage.
  • StorageFileID: Identifier for the storage file.
  • Size: Size of the storage in bytes.


This output helps you identify which dictionary storages are consuming the most space, allowing you to optimize your data model for better performance.


https://dax.guide/info-dictionarystorages/

Comments

Post a Comment

Popular posts from this blog

Daily DAX : Day 65 INFO.TABLEPERMISSIONS

 A metadata DAX function that returns a list of all table permissions in the current model with columns matching the schema rowset for table permissions objects Syntax INFO.TABLEPERMISSIONS(<RestrictionName>,<RestrictionValue>) Returns a table with the following fields Field Type ID Integer RoleID Integer TableID Integer FilterExpression String ModifiedTime DateTime State Integer ErrorMessage String MetadataPermission Integer https://dax.guide/info-tablepermissions/
Read more

Daily DAX : Day 55 PV

A financial DAX function that calculates the present value of a loan or an investment, based on a constant interest rate. You can use PV with either periodic, constant payments (such as a mortgage or other loan), or a future value that’s your investment goal. Syntax PV(<Rate>, <Nr_of_Periods>,<Payments_per_period>,<Future_Value>,<Type>) https://dax.guide/pv/
Read more