Measure or Column Type

[jflores]

Hello comminity, I have simple Sum Measures for each cost type that are just

Sum Material Costs = Sum(All_Costs[Material]).  For some reason, Sum Material shows up as a column type where all the others correctly display measure type.  All field types under All_Costs are numbers.  I've tried removing the column from the model then re-adding it with no success.  Does anyone have any thoughts on this?

[Anonymous]

Hi  @jflores ,

Sorry, after testing, my display is normal and cannot reproduce your scenario

You can check the following:

Check if there are any relationships between the table containing the Sum Material Costs column and other tables that might be causing the issue.

Check if there are any filters or slicers applied to the visual that might be causing the issue.

Is the version of Power BI Desktop up to date, if not, please update and reopen it in the link below.

https://www.microsoft.com/en-us/download/details.aspx?id=58494

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data. We can better understand the problem and help you.

Best Regards,

Liu Yang

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

[jflores · Accepted solution]

Thank you,

I deleted the measure and recreated it and that solved the problem.  Thank you for your response.