Search found 844 matches

by MattAllington
Sat Aug 19, 2017 7:53 pm
Forum: PowerPivot/DAX
Topic: Filtering in DAX
Replies: 1
Views: 10

Re: Filtering in DAX

I have looked at the attached workbook but cannot work out the relationship between that book and the problem you describe. If you can help explain exactly what is happening with a table showing the incorrect result and a manual table showing what you expect, then I can take another look for you.
by MattAllington
Sat Aug 19, 2017 5:03 pm
Forum: PowerPivot/DAX
Topic: Context Transition
Replies: 1
Views: 18

Re: Context Transition

In the first formula, the maxx function is operating in the initial filter context coming from the visual. That is how it works. In the second function, the additional calculate that you have added is changing the behaviour, and instead of the maxx function operating in the initial filter context, t...
by MattAllington
Fri Aug 11, 2017 8:01 am
Forum: General
Topic: Laptop specs [Solved]
Replies: 2
Views: 41

Re: Laptop specs [Solved]

I have been thinking about blogging about this (which I will do). In short. Go for fast processor speed >=3ghz is best and most important multi core (core 4 or above) >=8GB memory with fast and plenty of L2 and L3 cache. Not all memory is the same. Faster memory is better Not so important (prefer th...
by MattAllington
Fri Aug 11, 2017 6:01 am
Forum: PowerPivot/DAX
Topic: Cannot find the Query Editor in Excel 2106
Replies: 3
Views: 61

Re: Cannot find the Query Editor in Excel 2106

Strange (I guess you know that). Are you able to go into existing connections and browse to the file from there?
by MattAllington
Thu Aug 10, 2017 7:21 am
Forum: PowerPivot/DAX
Topic: Cannot find the Query Editor in Excel 2106
Replies: 3
Views: 61

Re: Cannot find the Query Editor in Excel 2106

If you import directly, then you should be able to bring up the import wizard by first selecting the table in Power Pivot, then select table properties. You can add the new column from there
by MattAllington
Wed Aug 09, 2017 6:24 am
Forum: PowerPivot/DAX
Topic: Change DAX Statement using VBA
Replies: 1
Views: 22

Re: Change DAX Statement using VBA

There is a vba object model in Excel 2016, but I have never used it. You could have a look to see what objects and methods exist inside vba.
by MattAllington
Tue Aug 08, 2017 8:28 am
Forum: PowerPivot/DAX
Topic: Find unique customers who own multiple products
Replies: 5
Views: 60

Re: Find unique customers who own multiple products

You don't need 3rd normal form for DAX.

Try this as a measure

CALCULATE(distinctcount(Customers[Name]),
filter(customers,Customers[Product] = "Product A" && Customers[Product] = "Product B" && Customers[Product] = "Product C"))
by MattAllington
Fri Aug 04, 2017 5:26 am
Forum: PowerPivot/DAX
Topic: 2 Facts Table Relationship [Solved]
Replies: 7
Views: 172

Re: 2 Facts Table Relationship [Solved]

If you can't work It out after reading the article, post back here
by MattAllington
Thu Aug 03, 2017 8:38 pm
Forum: PowerPivot/DAX
Topic: 2 Facts Table Relationship [Solved]
Replies: 7
Views: 172

Re: 2 Facts Table Relationship [Solved]

Yes. Read my blog posted above and then follow the pattern described there
by MattAllington
Thu Aug 03, 2017 8:29 pm
Forum: PowerPivot/DAX
Topic: 2 Facts Table Relationship [Solved]
Replies: 7
Views: 172

Re: 2 Facts Table Relationship [Solved]

I assume you mean you want to filter the SalesRev table with a column from the dAgency table. If that is correct, then read my blog post here https://exceleratorbi.com.au/many-many- ... explained/

Go to advanced search