Search found 6 matches

by Jen
Fri Feb 19, 2016 6:08 am
Forum: Help with the Book "Learn to Write DAX"
Topic: Possible error on pg 96: [Total Selected Groups/Territories]
Replies: 1
Views: 1807

Possible error on pg 96: [Total Selected Groups/Territories]

The measure created in the middle of the page, [Total Selected Groups] is then subsequently described (I think) as [Total Selected Territories]...
by Jen
Fri Feb 19, 2016 5:19 am
Forum: Help with the Book "Learn to Write DAX"
Topic: Pg 94 - Possible discrepancy in pivot table results
Replies: 0
Views: 1828

Pg 94 - Possible discrepancy in pivot table results

The instructions from pg 92 have you set up a pivot table with Territories[Country] on Rows. But the images on pg 94 have Territories[Region] on Rows.

pg 94.PNG
pg 94.PNG (22.29 KiB) Viewed 1828 times
by Jen
Fri Feb 19, 2016 4:58 am
Forum: Help with the Book "Learn to Write DAX"
Topic: Pg 92 - Wrong (?) instructions to edit Value Field Settings
Replies: 1
Views: 1752

Pg 92 - Wrong (?) instructions to edit Value Field Settings

The instructions on pg 92, 2nd paragraph, say, "It is then possible to go to the PivotTable Fields list, right-click on the calculated field [Total Sales Amount], and select Value Field Settings." I'm using Excel 2013, and for me it is just a standard left-click. A right-click does nothing.
by Jen
Thu Feb 18, 2016 9:19 am
Forum: Help with the Book "Learn to Write DAX"
Topic: Context transition example on pg 79 not working for me
Replies: 4
Views: 2693

Context transition example on pg 79 not working for me

On pg 79, I couldn't get the calculated column example to work:

    =SUM(Sales[ExtendedAmount]) "correctly" gives me a column of 29358677.220702...
    =CALCULATE(SUM(Sales[ExtendedAmount])) gives me a column of blanks, not the expected total sales for each product
What am I doing wrong?
by Jen
Tue Feb 16, 2016 1:35 pm
Forum: Help with the Book "Learn to Write DAX"
Topic: Appendix A: Answers to Practic Exercises
Replies: 4
Views: 3190

Re: Appendix A: Answers to Practic Exercises

On Pg 50... For #21, we're told to use [Margin $] and [Total Sales]. If you mean to use the full name of the measure, shouldn't they be [Total Margin $] and [Total Sales Amount]? (The answer key (pg 176) does use the full names.) Ditto, for #22, we're told to use [Margin $] and [Cost Price], which a...
by Jen
Tue Feb 16, 2016 10:09 am
Forum: Help with the Book "Learn to Write DAX"
Topic: Appendix A: Answers to Practic Exercises
Replies: 4
Views: 3190

Appendix A: Answers to Practic Exercises

Assuming I am working off the correct version of the Access database (Matt sent me a link to the file in Dropbox), there are naming inconsistencies between the Access database and the answers, as well as inconsistencies within the book itself. Appendix A: Answers... (pg 175) A. SUM() #3. Answer refe...

Go to advanced search