Formula with different result in Desktop than Excel 2016

[masplin]

I have bene transcribing my Excel modle inot Desktop assumnig DAX works exactly the same.  I have a calcaution for working out how many working days there are in a period. It varies slightly by Centre because we areo pening new centres so has to take account of opening date.

My measure is

=CALCULATE(
CALCULATE(
COUNTROWS(DateTable),
FILTER(
DateTable,
DateTable[Closed for Business]=blank() &&
DateTable[Day]<=
CALCULATE(MAX('Posted Document Header'[Posting Date])) &&
DateTable[Day]>=MIN('Centre'[Opening Date])
)
),
ALLEXCEPT('Posted Document Header',Centre,DateTable)
)

This works correctly in excel returning 26 days in Jun no matter waht other slicers I have or rows on pivot as below

	Jun-17
Type/Source/Camp	Car Count per Day	Car Count	Days in Period
WORD OF MOUTH	0.08	2	26
SOCIAL MEDIA			26
SIGNAGE	2.46	64	26
REPEAT CUSTOMER	0.81	21	26
OTHER	0.04	1	26
DIGITAL	2.19	57	26
DEAL SITE			26
AFFILIATE	0.23	6	26
ADVERTISING	0.04	1	26
Grand Total	5.85	152	26

However I have copied everythnig idneitcally to Desktop and get this

So it is passing the marketing fields into the calculation. For example Word of Mouth we had 2 visits on 26th and 30th june.

First question is why does this work fine in Excel and not in Desktop?

Secondly how do I fix it as pretty sure my ALLEXCEPT statement is correct!!!!!

Pretty worrrying as i have hundered of measures that are fully tested, but I havent retested all of them in Desktop

Thanks

Mike

[masplin · Accepted solution]

Found it. Somehow managed to add a bracket in fornt of MIN and Desktop automatically added a bracket at the end instead of just giving an error.