Search found 10 matches

by mlmittelman
Thu Feb 25, 2021 12:24 pm
Forum: PowerPivot/DAX
Topic: DISTINCTCOUNT Grand Total incorrect
Replies: 2
Views: 329

Re: DISTINCTCOUNT Grand Total incorrect

Hi Matt: Thanks very much for your reply . . . have been playing around with your formula suggestion: Sumx(values(table[month ID]),calculate( CALCULATE ( DISTINCTCOUNT ( DATA[NAME] ) , DATA[HOURs] > 0 )) But it seems to be overriding the pivot filter on the CODE values . . . will keep at it; thanks ...
by mlmittelman
Mon Feb 22, 2021 5:47 am
Forum: PowerPivot/DAX
Topic: DISTINCTCOUNT Grand Total incorrect
Replies: 2
Views: 329

DISTINCTCOUNT Grand Total incorrect

Howdy: This is driving me slowly insane . . . have tried various CALCULATE / SUMX / SUMMARIZE -based measures and, at last, got the SUBTOTALs correct, but the GRAND TOTALs are still not summing the DistinctCount values but (I'm assuming) calculating the DistinctCount values for the entire date range...
by mlmittelman
Mon Dec 16, 2019 8:17 am
Forum: Help with the Book "Learn to Write DAX"
Topic: Manage Measures dialog box is empty on open / PowerPivot file crashes Excel on open
Replies: 4
Views: 2016

Re: Manage Measures dialog box is empty on open / PowerPivot file crashes Excel on open

The previously mentioned 'fix' failed after a day or two and the downgraded version of Excel began to exhibit the same behavior . . . the then, today: Just wanted to add one more update . . . I did the test I should have done from the very beginning: I opened the file on another computer with Office...
by mlmittelman
Mon Dec 09, 2019 5:30 am
Forum: Help with the Book "Learn to Write DAX"
Topic: Manage Measures dialog box is empty on open / PowerPivot file crashes Excel on open
Replies: 4
Views: 2016

Re: Manage Measures dialog box is empty on open / PowerPivot file crashes Excel on open

Just wanted to share my issue resolution from MS Support: (as of 12-08-2019) one of the advantages of the new MS Subscription model is that you retain access to MS Support: Turns out I do have the latest version of Office 365, Version 1911, which is fairly recent. The MS tech downgraded me to prior ...
by mlmittelman
Sun Dec 08, 2019 2:59 am
Forum: Help with the Book "Learn to Write DAX"
Topic: Manage Measures dialog box is empty on open / PowerPivot file crashes Excel on open
Replies: 4
Views: 2016

Re: Manage Measures dialog box is empty on open / PowerPivot file crashes Excel on open

Hello All: Apologies . . . I knew I should have tested *before* I posted above . . . although it appeared to be the solution last evening, when I opened the file in a fresh Excel session this morning, Excel crashed. The only 'fix' I seem to have found is that, if I have another file open when I open...
by mlmittelman
Sun Dec 08, 2019 2:41 am
Forum: Help with the Book "Learn to Write DAX"
Topic: Manage Measures dialog box is empty on open / PowerPivot file crashes Excel on open
Replies: 4
Views: 2016

Re: Manage Measures dialog box is empty on open / PowerPivot file crashes Excel on open

Hello All: Regarding, Curious Behavior #2: "The same file, AW_01.xlsx, opens normally on my work laptop but, on my home PC, about 50% of the time, when I open the file, Excel instantly vanishes. It's an instantaneous crash." After some research I finally found an answer for Curious Behavio...
by mlmittelman
Thu Dec 05, 2019 12:17 pm
Forum: Help with the Book "Learn to Write DAX"
Topic: Manage Measures dialog box is empty on open / PowerPivot file crashes Excel on open
Replies: 4
Views: 2016

Manage Measures dialog box is empty on open / PowerPivot file crashes Excel on open

Hello All: Actually, I have two curious PowerPivot-related behaviors that you may have insight into . . . but, first, here is my scenario: I have Excel 365 (as part of an Office 365 Personal subscription) on my home PC and Excel 365 ProPlus on my work laptop, both in a 64 bit WIN 10 environment. I h...
by mlmittelman
Thu Nov 07, 2019 8:49 am
Forum: Help with the Book "Learn to Write DAX"
Topic: Table Properties displays SQL statement only . . .
Replies: 4
Views: 1574

Re: Table Properties displays SQL statement only . . .

Ah, OK . . . That is helpful.
Thanks, Ramana!
by mlmittelman
Wed Oct 23, 2019 11:39 am
Forum: Help with the Book "Learn to Write DAX"
Topic: Table Properties displays SQL statement only . . .
Replies: 4
Views: 1574

Re: Table Properties displays SQL statement only . . .

Hi Matt: Thanks for taking the time to respond to me, personally! I appreciate it. I am reading LEARN TO WRITE DAX . . . I know I'm late to the Power Pivot party; in fact I always favored formula-based solutions in EXCEL over pivot tables. I suppose I was a bit of a formula snob; I thought pivot tab...
by mlmittelman
Mon Oct 21, 2019 3:46 am
Forum: Help with the Book "Learn to Write DAX"
Topic: Table Properties displays SQL statement only . . .
Replies: 4
Views: 1574

Table Properties displays SQL statement only . . .

Hello All: Apologies for super-newbie question (and more to come): As I begin the book and am directed to the Table Properties dialog for the Calendar table, I only see the SQL statement; I do not see the table itself. (please see screenshot). I am using MS OFFICE 365. How do I get the Table Propert...

Go to advanced search

cron