Analyst in Action

As a Power BI developer, whenever you connect a dataset, you often see sigma in front of different fields in your table. What is the significance of this sigma and how will it hamper the performance of your dashboard? We will answer all those questions in this article. Let's dig deeper into all the fields with some symbols such as sigma called Implicit measures. Such measures are automatically created by Power BI which is a default setting so whenever you drag such a measure into a table or any visual it will provide a sum (if the sigma is in front of that field). Let's try it with a sample dataset. I am using the SampleSuperstore dataset. We will be checking the profit associated with different categories. I am taking both category and profit in the table. In the below-mentioned image, you can see we are getting profit with every category. Easy peasy!!!! in such a case default does the job but what if we don't want a sum. To obtain that go to the columns and select the dro...