Chapter 11 Values

A dedicated forum to help people when working through the book "Learn to Write DAX"
Posts: 2
Joined: Thu Sep 14, 2017 6:49 am

Chapter 11 Values

Postby BradleyA » Wed Sep 20, 2017 12:20 am

Hello, everyone

I am in the beginning of Chapter 11, trying to get the number of months in each year. The book shows
2001 - 6
2002 - 12
2003 - 12
2004 - 12

I am getting 13 for all years. No 6's no 12's :cry:

This is my formula:
Total Months in Calendar = COUNTROWS(VALUES('Calendar'[MonthName]))

I am using Power BI (July 2017 update). I made a table visualization and selected "Do not summarize" for both year and month count in the values section.

Any assistance is appreciated!

Posts: 2
Joined: Thu Sep 14, 2017 6:49 am

Re: Chapter 11 Values

Postby BradleyA » Wed Sep 20, 2017 12:53 am

I fixed the relationship for my calendar table and now I am getting all 12's instead of 13's. Still no 6 for 2001.

(I did all exercises already, but I am fixing relationships now since I am switching from using Access Tables to Queries as the data source. I thought the instructions said to use tables and replace "dim" prefix, but then it seems like column names in examples/exercises refer to the queries i.e. MonthName vs. EnglishMonthName).

Capstone Analytics
Posts: 1
Joined: Fri Nov 10, 2017 9:59 am

Re: Chapter 11 Values

Postby Capstone Analytics » Fri Nov 10, 2017 10:04 am

Hi Bradley,

I replicated the DAX formula in my Power BI Desktop model (October 2017 update) and I'm getting the correct values. I imported the Dim and Fact tables and the relationships were automatically generated.

Capture.PNG (6.13 KiB) Viewed 3990 times

Posts: 5
Joined: Sat Dec 16, 2017 1:04 am

Re: Chapter 11 Values

Postby Krishna » Sun Dec 31, 2017 4:54 pm


using Nov 2017 update and i got same result as Abhijith. i removed relationship with other tables and still getting correct result :)


Return to “Help with the Book "Learn to Write DAX"”

Who is online

Users browsing this forum: No registered users and 1 guest