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)
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]