Issue With My Measure In The Composite Model

[Addams_Katherin]

Hi experts, I'm new to the forum and I've recently encountered a problem that I don't know how to solve and would like your help.

When I use this measure in a composite model, I encounter an error.

Measure = IF(MAX('Table'[ID])="A",MAX('Table'[Value])/SUM('Table'[Value]), MAX('Table'[ID]))

Thanks.

[Anonymous]

Hi @Addams_Katherin 

It's normally in my sample . Please check the data type of your column 'Table'[Value] .

Best Regards,
Community Support Team _ Ailsa Tao

[Addams_Katherin]

Hi @Anonymous  thank for your reply.

My measure format is General, I changed it to "whole number" as shown in your picture, but the visual is still broken.

btw my table[value] is whole number.

[Addams_Katherin]

Hi @Anonymous ,

I fond a way online, recreate the same measures in the composite model. but this is not suitable for my case, I have a large number of similar measures in my dataset (return text and numbers), so it is impossible to recreate them. Is there other ways to solve this problem?