Power BI From SharePoint List shows calculated column as text

Question

A sharepoint list Column is calculated from others columns as this:

When I Integrate with Power BI the calculated formula doesn't allow me to summarize, just a count:

Did I do something wrong?

Answer 1

Hi @Sergio ,

The reason why you can't summarize your calculated column in Power BI is likely due to the fact that it is being recognized as a text field instead of a numeric field. This can happen if the field is not properly classified as a number in the semantic model. To fix this issue, you will need to open the semantic model in Power BI Desktop and use the Modeling tab to change the data type of the field to a numeric type. If you are not the owner of the semantic model, you will need to contact the owner for assistance.

Another possibility is that you've dropped the field into a bucket that only allows categorical values. In that case, your only options will be count and distinct count.

Reference:https://learn.microsoft.com/en-us/power-bi/create-reports/service-aggregates#considerations-and-troubleshooting

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.