Chapter 4 and error messages with aggregated functions

A dedicated forum to help people when working through the book "Learn to Write DAX"
kkardynalski
Posts: 3
Joined: Sat Dec 19, 2015 2:27 am

Chapter 4 and error messages with aggregated functions

Postby kkardynalski » Sun Dec 20, 2015 5:25 am

I have had the error message shown on page 34 multiple times, and I have read blogs about "row context" and "filter context" trying to understand it. This sentence from the book
Think about the column Sales[ExtendedAmount], which has more than 60,000 rows of data. You can't simply put the entire column into a pivot table because the pivot table can't "fit" a column into a single cell on the spreadsheet.
finally makes the light click for me!

MattAllington
Posts: 929
Joined: Sun May 04, 2014 4:01 pm
Location: Sydney, Australia

Re: Chapter 4 and error messages with aggregated functions

Postby MattAllington » Wed Dec 23, 2015 1:05 pm

Glad it helped :-)
Matt Allington is Self Service BI Consultant, Trainer and Author of the book "Supercharge Power BI".
https://exceleratorbi.com.au/power-bi-online-training/

cwsco
Posts: 1
Joined: Wed Jun 15, 2016 7:52 pm

Re: Chapter 4 and error messages with aggregated functions

Postby cwsco » Wed Jun 15, 2016 8:00 pm

Hi, new fro Melbourne and facing the same problem and trying to put light on the same issue. I think I can transfer data from all cells from other sheet to new sheet and it will placed in the same way in all cells. Could I copy from excel and and transfer into pivot, possible?
Shop lighting online Australia http://www.clicknbuyaustralia.com/lighting/ like ceiling lights, chandeliers, floor lamps, pendant lights at Click N Buy Australia.

MattAllington
Posts: 929
Joined: Sun May 04, 2014 4:01 pm
Location: Sydney, Australia

Re: Chapter 4 and error messages with aggregated functions

Postby MattAllington » Fri Jun 24, 2016 6:54 pm

Sorry. Just saw your post. I don't understand what you are saying. Can you rephrase?
Matt Allington is Self Service BI Consultant, Trainer and Author of the book "Supercharge Power BI".
https://exceleratorbi.com.au/power-bi-online-training/


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

Who is online

Users browsing this forum: No registered users and 2 guests