Search found 6 matches

by P3Tom
Wed Jan 10, 2018 8:40 am
Forum: Help with the Book "Supercharge Power BI"
Topic: #51 & #52 p99
Replies: 2
Views: 371

Re: #51 & #52 p99

mfl, An excellent observation! I have thought about this one for a while: You have the correct matrix, but perhaps not the correct slicer. The example on page 99 of Supercharge Power BI uses a slicer with a column from the same table (Customers[Occupation]) as the column used on the rows of the pivo...
by P3Tom
Wed Jan 10, 2018 3:23 am
Forum: PowerPivot/DAX
Topic: Context transition in measures
Replies: 13
Views: 537

Re: Context transition in measures

Marc, I refer you to page 117 of the Definitive Guide to DAX, by Marco Russo and Alberto Ferrari (authorities of the DAX language both outside and inside of Microsoft): "There is an order of precedence between the filter context created by context transition and the filter context created by th...
by P3Tom
Wed Jan 10, 2018 2:31 am
Forum: PowerPivot/DAX
Topic: Show top 3 and group rest values.
Replies: 2
Views: 219

Re: Show top 3 and group rest values.

Please advise what version of Excel you are using (or if you are using Power BI Desktop).

Also, always helps if you can provide a some sample data in a workbook. Does not need to be much, only enough to show your case.
by P3Tom
Tue Jan 09, 2018 5:40 pm
Forum: Help with the Book "Learn to Write DAX"
Topic: Chapter 16 Disconnected Tables: Banding
Replies: 2
Views: 197

Re: Chapter 16 Disconnected Tables: Banding

For starters, since TODAY() is a date, you could simplify your calculated column's formula for Age: Age = IF ( NOT ( ISBLANK ( Customers[BirthDate] ) ), ROUNDDOWN ( ( TODAY () - Customers[BirthDate] ) / 365, 0 ) ) Also, I would say that Age Group is probably for a calculated column, since the measur...
by P3Tom
Tue Jan 09, 2018 5:16 pm
Forum: PowerPivot/DAX
Topic: Bill of Material - Multi level with Stock
Replies: 1
Views: 203

Re: Bill of Material - Multi level with Stock

I think your requirement is better resolved with a procedural language instead of DAX.
by P3Tom
Tue Jan 09, 2018 5:11 pm
Forum: PowerPivot/DAX
Topic: Context transition in measures
Replies: 13
Views: 537

Re: Context transition in measures

Marc, A thoughtful question! You may or may not know that measures are automatically wrapped inside of a CALCULATE (see page 109, Learn to Write DAX). So the DAX engine unpacks your "context transition" formula as: Context Transition := CALCULATE ( CALCULATE ( CALCULATE ( CALCULATE ( SUM (...

Go to advanced search