error message in measure after a year of working

[ahumke]

Have an error that says MdxScript(Model) (69,62) Calculation error in measure: A table of multiple values was supplied where single value was expected.  

This measure has worked fine for over a year. THere were two years of data in the model and I added a third then it broke. It broke on 5 out of 10 metrics that all use simlar formulas (only difference being the specified benchmark). I don't at all understand why it isn't working now for half the metrics when the data change impacted them all the same and it there aren't multiple values after the metric filters to this level.

MHStudentSupportSucceed = (CALCULATE(MAX('CCSSE Excel'[Score]),FILTER('CCSSE Excel', 'CCSSE Excel'[Benchmark]="Student Support to Succeed"),FILTER('CCSSE Excel', 'CCSSE Excel'[Group] = "MCC"),FILTER('CCSSE Excel', 'CCSSE Excel'[Year] = 2021)))

Feedback Type:
Frown (Error)

Timestamp:
2021-08-26T20:58:11.8310646Z

Local Time:
2021-08-26T15:58:11.8310646-05:00

Session ID:
624c7dd6-cdc2-4481-b8f4-5bd64f485eb4

Release:
January 2021

Product Version:
2.88.2361.0 (20.12) (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.6 GB

Private Memory:
649 MB

Peak Working Set:
878 MB

IE Version:
11.719.18362.0

User ID:
5d73ad4a-c826-4d0d-ad97-95e770488400

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

Telemetry Enabled:
True

Model Default Mode:
Import

Model Version:
PowerBI_V3

Is Report V3 Models Enabled:
True

Enabled Preview Features:
PBI_NewWebTableInference

Disabled Preview Features:
PBI_shapeMapVisualEnabled
PBI_SpanishLinguisticsEnabled
PBI_JsonTableInference
PBI_ImportTextByExample
PBI_ExcelTableInference
PBI_qnaLiveConnect
PBI_v3ModelsPreview
PBI_eimInformationProtectionForDesktop
PBI_azureMapVisual
PBI_dataPointLassoSelect
PBI_compositeModelsOverAS
PBI_narrativeTextBox
PBI_dynamicParameters
PBI_anomalyDetection
PBI_newFieldList
PBI_cartesianMultiplesAuthoring

Disabled DirectQuery Options:
TreatHanaAsRelationalSource

Cloud:
GlobalCloud

DPI Scale:
100%

Supported Services:
Power BI Report Server, Power BI

[v-chuncz-msft]

@ahumke 

The DAX formula seems fine. You may try the latest version of Power BI Desktop.