Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

0

Issue With My Measure In The Composite Model

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

Addams_Katherin_0-1675044754938.png

 

Thanks.

Status: Delivered

Hi @Addams_Katherin 

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

Ailsamsft_1-1675129395806.png

Ailsamsft_2-1675129427578.png

 

Best Regards,
Community Support Team _ Ailsa Tao

Comments
v-yetao1-msft
Community Support
Status changed to: Delivered

Hi @Addams_Katherin 

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

Ailsamsft_1-1675129395806.png

Ailsamsft_2-1675129427578.png

 

Best Regards,
Community Support Team _ Ailsa Tao

Addams_Katherin
New Member

Hi @v-yetao1-msft  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.

Addams_Katherin_0-1675150911026.png

 

btw my table[value] is whole number.

 

 

Addams_Katherin
New Member

Hi @v-yetao1-msft ,

 

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?