Getting started with DAX – Employee Data Analysis

We will continue using the Employee Data set from previous lesson to build DAX understanding. In this lesson, learn all about:

  • Creating measures
  • How measures can be reused
  • Filter context explained
  • Nature measures

Author: Chandoo

My name is Chandoo. I am going to make you awesome in Excel, VBA, Dashboards, Power BI & Power Pivot and answering your questions. I live in Wellington, New Zealand. It is a beautiful, small city on the southern edge of the world. I run my own Excel Consulting & Training business from here. I am married to my college sweet-heart, Jo. We have 2 kids – twins. They are 10 years old now. They are busy creating new worlds with lego bricks or playing or learning. We (Jo &I) are busy with cooking, eating, walking, talking and reading.

4 thoughts on “Getting started with DAX – Employee Data Analysis”

  1. Hello Chandoo..
    Thank you so much for such a wonderful explanation.
    I have a question – I wanted to know when you add a new measure | All Staff Count = CALCULATE ([Employee count], ALL (Staff)) and its result was 100, but is is possible to get total for “Male” and Female” = 98 as the result and that 98 can be used as base to get %age Staff…

    Regards
    Kunal Seth

  2. Dear Chandoo,

    Could you please assist me in understanding topics related to data modeling, including relationships, fact tables, and dimension tables explanation, as well as different types of schemas and cardinality, as these are integral parts of Power BI? From which module I can get ??

    Looking forward…

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.