cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Calculated coumn shows a sigma symbol with RED background in the report view

Hello everyone,

Sometimes, when I make calculated columns, a Sigma with RED background appears instead of the normal, white one (see picture below).

What does it mean? I didn't find anything seatching in the forum or googling.

 

Someties it appears in columns of a lot of calculations, sometimes in the simplest one like Column3 = Column2.

This red symbol only appears in the report view. It shows the normal calculated column symbol in the table view.

 

Thanks in advance!

Sin título.png

7 REPLIES 7
Highlighted
Super User IV
Super User IV

Re: Calculated coumn shows a RED sigma symbol in the report view

@ary_szpic it is to represent that it is a calculated column by using DAX, column is not coming directly from your data source. 

 






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





Highlighted
Frequent Visitor

Re: Calculated coumn shows a RED sigma symbol in the report view

Normal DAX calculated column symbol has a white background, not red..

Highlighted
Super User IV
Super User IV

Re: Calculated coumn shows a RED sigma symbol in the report view

@ary_szpic , this calculated column. 

refer at the end of page https://docs.microsoft.com/en-us/power-bi/create-reports/service-the-report-editor-take-a-tour



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
My Recent Blog -Week is not so Weak Connect on Linkedin

Proud to be a Super User!

Highlighted
Super User IV
Super User IV

Re: Calculated coumn shows a RED sigma symbol in the report view

@ary_szpic you are correct didn't see this before. Can you share the expression where you have this red background, I want to see if there is anything in those calculations, just copy-paste the dax expression of those two red background columns.






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





Highlighted
Frequent Visitor

Re: Calculated coumn shows a RED sigma symbol in the report view

@amitchandak I have seen that page, it doesn't say what the sigma with red background is...

Highlighted
Super User IV
Super User IV

Re: Calculated coumn shows a RED sigma symbol in the report view

@ary_szpic can yo paste the dax expression for these calculated columns?






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





Highlighted
Community Support
Community Support

Re: Calculated coumn shows a sigma symbol with RED background in the report view

hi  @ary_szpic 

Not sure why there is RED background in the field, if you uninstall and reinstall power bi desktop and try it again.

And it is a great help that you could share your sample pbix file for us to have a test on our side.

 

Regards,

Lin

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

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Upcoming Events

Upcoming Events

Wondering what events you could join or have an event to promote yourself? Check out our Upcoming Events.

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

We are thrilled to announce we will begin running a monthly webinar series named Power BI Dev Camp.

Top Solution Authors
Top Kudoed Authors