Sqldumper error when using a count DAX function with a filter in composite model

[ihafidh]

I get a sqldumper error when using the following DAX function. This error started to ocurr after converting to a composite model.

CountOrders = CALCULATE(COUNT(Orders[OrderNum]),Orders[CurrentStatus]<>"X")

Changing the above DAX to a SUM works but I need it to work with COUNT. 

Here is the error message:

Feedback Type:
Frown (Error)

Timestamp:
2020-10-16T20:38:10.5725413Z

Local Time:
2020-10-16T15:38:10.5725413-05:00

Session ID:
494329bb-9b63-439d-b111-66cb7a4f991f

Release:
September 2020

Product Version:
2.85.985.0 (20.09) (x64)

OS Version:
Microsoft Windows NT 10.0.18363.0 (x64 en-US)

CLR Version:
4.7 or later [Release Number = 528040]

Peak Virtual Memory:
38.3 GB

Private Memory:
645 MB

Peak Working Set:
912 MB

IE Version:
11.1139.18362.0

User ID:
f1cec79b-cdde-4212-a50a-c1726ece683d

Workbook Package Info:
1* - en-US, Query Groups: 0, fastCombine: Disabled, runBackgroundAnalysis: False.

Telemetry Enabled:
True

Model Default Mode:
Composite

Model Version:
PowerBI_V3

Is Report V3 Models Enabled:
True

Enabled Preview Features:
PBI_NewWebTableInference
PBI_inlineExplore

Disabled Preview Features:
PBI_shapeMapVisualEnabled
PBI_SpanishLinguisticsEnabled
PBI_ImportTextByExample
PBI_qnaLiveConnect
PBI_dataSearchCuration
PBI_azureMapVisual
PBI_dataPointLassoSelect
PBI_narrativeTextBox

Disabled DirectQuery Options:
TreatHanaAsRelationalSource

Cloud:
GlobalCloud

DPI Scale:
250%

Supported Services:
Power BI

[v-chuncz-msft]

@ihafidh 

I cannot reproduce the issue. You may try the latest version to recreate the report.

[ihafidh]

I was able to fix this issue just in case anyone else is having the same error.

Here is the updated DAX statement that works:

CountOrders = CALCULATE(COUNT(Orders[OrderNum]), NOT(Orders[CurrentStatus]="X"))

For some reason the <> operator does not work with composite models.