Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

NII5BG

SUM function cannot work with values of type String error / Couldn't Load the data for this vis

Submitted by on ‎05-30-2022 08:56 AM

I am as well new in Power BI and have same / similar problem.

Error message: MdxScript (Model) (6, 25) calculation error in measure ‚CSV‚(Area1): The function SUM cannot work with values of type String.

2022-05-30_16h02_09.pngWhat should i do?

Thank you

Status: Investigating
See more ideas labeled with:
4 Comments (4 New)
Comments
Anonymous
Not applicable
‎05-30-2022 07:37 PM

Hi @NII5BG 

Please make sure the data you loaded to PowerBI desktop is in correct format, especially the calculation which should be number type.

Ailsamsft_0-1653964476027.png

Best Regards,
Community Support Team _ Ailsa Tao

 

 

 

NII5BG
Regular Visitor
‎05-31-2022 12:22 AM

hello, thank you on your feedback.

I actualy dont see what is wrong in formula, please see photos attached.

 

Thank you 2022-05-31_09h20_25.png2022-05-31_09h20_37.png2022-05-31_09h20_48.png2022-05-31_09h20_56.png

Anonymous
Not applicable
‎06-01-2022 11:28 PM

Hi @NII5BG 

What is the format of column [Population] ?  Can you show me the step "Inserted Division" ? 

 

Best Regards,
Community Support Team _ Ailsa Tao

NII5BG
Regular Visitor
‎06-03-2022 01:51 AM

hello, thank you on your reply

please see attached photos.

thank you2022-06-03_10h42_48.png2022-06-03_10h46_59.png

Idea Statuses