## Search found 926 matches

Sat Apr 21, 2018 7:36 am
Forum: PowerPivot/DAX
Topic: COUNTROWS + VALUES vs DISTINCTCOUNT?
Replies: 3
Views: 40

### Re: COUNTROWS + VALUES vs DISTINCTCOUNT?

How do you know this stuff Jes?
Mon Apr 16, 2018 8:16 am
Forum: General
Topic: How to decide what to use?
Replies: 1
Views: 40

### Re: How to decide what to use?

Interesting problem. It is hard for me to give you clear advice on this despite the detail you have provided. Power Pivot is great for working over large tables of data. Excel is great for working on bespoke calculations. If you can load data into tables for processing, then Power Pivot it is great,...
Mon Apr 16, 2018 7:26 am
Forum: Help with the Book "Learn to Write DAX"
Topic: Using Filter Inside Calculate
Replies: 1
Views: 42

### Re: Using Filter Inside Calculate

What formula would you write to count the number of customers that have sales > 5000 over all time?
Mon Apr 16, 2018 6:51 am
Forum: PowerPivot/DAX
Topic: COUNTROWS + VALUES vs DISTINCTCOUNT?
Replies: 3
Views: 40

### Re: COUNTROWS + VALUES vs DISTINCTCOUNT?

= COUNTROWS ( VALUES (Table[Column])) vs = DISTINCTCOUNT (Table[Column]) There is no one right or wrong way. Sometimes one way is better but even then it is often personal preference. My book is designed to teach you reusable concepts, and in this case I was teaching you that you can create virtual...
Sat Mar 17, 2018 4:46 pm
Forum: Help with the Book "Supercharge Power BI"
Topic: database import error
Replies: 2
Views: 414

### Re: database import error

For the record, I sorted this for fatanalyst. Contact me at my website if you have a similar issue
Wed Feb 28, 2018 5:36 am
Forum: PowerPivot/DAX
Topic: Relationship Cardinality
Replies: 2
Views: 327

### Re: Relationship Cardinality

Very strange. I will be at Microsoft next week. I will add this to the list of things to follow up on (unless someone else knows.
Sun Feb 25, 2018 6:47 pm
Forum: PowerPivot/DAX
Topic: Lookup formula from excel to dax
Replies: 1
Views: 266

### Re: Lookup formula from excel to dax

Wed Feb 14, 2018 6:18 pm
Forum: PowerPivot/DAX
Topic: duplicates
Replies: 3
Views: 483

### Re: duplicates

Maybe you could be a bit more specific?
Mon Feb 05, 2018 6:35 am
Forum: General
Topic: Error Message
Replies: 2
Views: 621

### Re: Error Message

What version of Excel? Excel 2016 is the most risky (I always keep incremental backups)

Read my article here Power Pivot Crashes
Maybe also try migrating the data model to Power BI as a way of saving it
Thu Feb 01, 2018 7:18 am
Forum: PowerPivot/DAX
Topic: Measure to Sum the Lower Levels.
Replies: 2
Views: 553

### Re: Measure to Sum the Lower Levels.

The issue is that you can't complete the calculation you are trying to do at the aggregate level. You need to do it line by line.

This should work =sumx(VALUES(Table1[Level 2 Prodcut]),([ASP 2a]-[ASP 1a])*[Qty 1])

To understand why, read my article SUM vs SUMX Explained