In my day to day work I work with DAX, it is a routine for me to create measures and query data for the user requirements, in my personal experience DAX allows to see what you can not simply see, it's a revolution of identifying what do you have in your hands, so I thought of highlighting few points and elaborating more on the usage of DAX. First and foremost the important fact is there are three types of calculations that can be defined using DAX in a model and they are as following. 1. Calculated Columns 2. Calculated Tables 3. Measures Even though we have both MDX and DAX for querying if we are adding a logic to the model it can only be achieved by DAX, Dax can also be used to add row level security, if we consider Power BI we can create roles and assign those roles with restricted data. For an example if we have regional data for China, United States and Japan and we need to allow Jhon to access only the data for China we can cre