The following system error occurred: type mismatch - only happen when its a measure in visual

[Anonymous]

I have create a measure and a calculated column using the same expression:

A = if(SUM(UP[UCC])<>0,DIVIDE(sum(CUSTOMER[PosWri]), sum(UP[UCC]),BLANK()))

However, if the measure gets dragged into a visual, this error occurs, but the calculated column will not.

I try to understand what is the reason? what is the difference?

Thanks.

[v-xiaoyan-msft]

Hi @Anonymous ,

Does the replies above solve your problem? If it has been solved, please mark the correct reply as the standard answer to help the other members find it more quickly.Thanks in advance for your kind cooperation!

If not，Would you mind telling me a more detailed description of your needs so that I can help you better?

Hope it helps,

Community Support Team _ Caitlyn

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

what happens when you try with this simplified version?

A = DIVIDE(sum(CUSTOMER[PosWri]), sum(UP[UCC]),BLANK())

[Anonymous]

some of my data in Up[UCC] is equal as 0 so it will give me an error.