Getting started with more DAX – Employee Data Analysis

This is a continuation of our discussion about DAX. In this lesson, we will explore themes about,

  • Counting staff as a % – using ALL to clear away filters
  • Using CALCULATE
  • More examples of CALCULATE – >100k salary staff count
  • Calculating gender pay gap

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.

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

  1. Hi Chandoo,
    The Completed workbook for “DAX-more” doesn’t include pages 2 or 3 that are covered in the lesson. Could you please upload the updated file?
    Thank you!
    Gaby

  2. Hi Candoo,
    I’m sure you probably cover it later on, but at about the 13:30 mark where you have the slicer filtering the table, would be an excellent example of the ALLSELECTED filter. This is one I struggled to understand at first.

Leave a Reply

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