Forum Discussion

jflores's avatar
jflores
Frequent Visitor
3 years ago
Solved

Measure or Column Type

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?

 

 

 

 

General Comment
Need Help
  • jflores's avatar
    jflores
    3 years ago

    Thank you,

     

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

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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's avatar
      jflores
      Frequent Visitor
      3 years ago

      Thank you,

       

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