Calculate the maximum choice score if 1 choice has no value

[James_Ma]

Hi, In the above choice group Ther are 4 options of which 3 have a value, however, Not Applicable has no value.

I have created the following measure

Max Unit Corrected =
SUMX(
SUMMARIZE(data_formanswer,
data_formanswer[data_name],
data_formanswer[data_answerchoiceid],
"Max Unit Corrected",
MAX(data_formchoiceitem[data_value])),
[Max Unit Corrected])

to calculate the Max score but if there is s choice group containing N/A then I want to remove all scoring from the maximum amount (see actual current max values below.

[johnbasha33]

@James_Ma 
try this
Max Unit Corrected =
SUMX(
FILTER(
SUMMARIZE(
data_formanswer,
data_formanswer[data_name],
data_formanswer[data_answerchoiceid],
"Max Unit Corrected", MAX(data_formchoiceitem[data_value])
),
[data_answerchoiceid] <> BLANK() && [data_answerchoiceid] <> "Not Applicable"
),
[Max Unit Corrected]
)
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!

[James_Ma]

Hi @johnbasha33 unfortunately thid did not work as this remoced the Max unit corrected score

[v-zhouwen-msft]

Hi @James_Ma ,

Can you provide simple data for table 'data_formanswer','data_formchoiceitem' and present the expected results as a picture?

If you are unsure how to upload data please refer to

How to provide sample data in the Power BI Forum - Microsoft Fabric Community

Best Regards,
Wenbin Zhou