Power BI CALCULATE function with Filtering Example

In this tutorial, I will show you how to write a Power BI measure using CALCULATE function with filtering.

Step 1: Download vehicle information sheet and load it to Power BI.

Step 2: Create the following PowerBI portal (Please follow this tutorial if you don't have an idea of creating this portal)



Step 3: As you can see, the Sum of the profit for product Car = 83184, and we are going to create a Power BI measure to get that value using the CALCULATE function.


Step 4: CALCULATE function consists of CALCULATE (Expression, Filters...)



Expression = SUM(Sheet1[Profit]) 

Filter = Sheet1[Product ]="Car"




Profit SUM = CALCULATE(SUM(Sheet1[Profit]),Sheet1[Product ]="Car")


Step 5: Drag and drop the Measure (Profit SUM) to the dashboard in Card visualization model. Here is your output.


Comments

  1. The Profit by Product chart I get has profit on the x axis and product on the y axis; how can I turned around so as to get your visual?

    ReplyDelete
    Replies
    1. You can use the visualization model: "Clustered bar chart" to achieve this.

      Delete
    2. Very useful Article. Thanks for sharing it!!!
      IntelliMindz is the best IT Training in Bangalore with placement, offering 200 and more software courses with 100% Placement Assistance.
      Power BI Online Training
      Power BI Course In Bangalore
      Power BI Training In Chennai

      Delete
  2. Thank you so much for providing such a descriptive and informative post throwing light on the aspects of REST API.

    Powerbi Read Rest

    ReplyDelete
  3. Thank you so much for the valuable information. Your information is very effective. We will try to incorporate this knowledge of Business Intelligence Courses in London. Visit More information:-BI Courses 

    ReplyDelete
  4. Very useful blog for beginners who look opportunity in Power BI. If you are looking for Real-Time Power BI Course in Bangalore Contact Boyina Soft for demo class.

    ReplyDelete
  5. Thanks for this amazing Power BI Blog. I found this interesting blog on MSN. You can also check my high quality Power BI Tutorial to get more knowledge about Power BI Training.

    ReplyDelete
  6. Your blog is very informative. Eating mindfully has been very hard for people these days. It's all because of their busy schedules, work or lack of focus on themselves. As a student I must admit that I have not been eating mindfully but because of this I will start now. It could help me enjoy my food and time alone. Eating mindfully may help me be aware of healthy food and appreciating food.
    Surge protector power board

    ReplyDelete
  7. I am truly inspired by this online journal! Extremely clear clarification of issues is given and it is open to every living soul. I have perused your post, truly you have given this extraordinary informative data about it.
    Power conditioner

    ReplyDelete
  8. I would like to thank you for the efforts you have made in writing this article. I am hoping the same best work from you in the future as well. In fact your creative writing abilities has inspired me to start my own BlogEngine blog now. Really the blogging is spreading its wings rapidly. Your write up is a fine example of it.
    Audio power conditioner

    ReplyDelete
  9. I recently came across your blog and have been reading along. I thought I would leave my first comment. I don't know what to say except that I have enjoyed reading. Nice blog. I will keep visiting this blog very often.

    Best powerbi Training

    ReplyDelete
  10. creativity of writer is purely impressive. It has touched to the level of expertise with his writing. Everything is up to the mark. Written perfectly and I can use such information for my coming assignment.Power filter surge protector

    ReplyDelete
  11. This comment has been removed by the author.

    ReplyDelete
  12. I would like to know more about these suggestive points. Give me little more brief and I think they can help me. Here the mentioned points are very useful and I am definitely going to adopt in my life.
    Best surge protector

    ReplyDelete
  13. Enjoyed reading the article above, really explains everything in detail, the article is very interesting and effective. Thank you and good luck for the upcoming articles Learn power bi online training
    power bi online training Hyderabad
    power bi online course
    power bi course
    power bi Training

    ReplyDelete
  14. Learn the art of creating productivity boosting Calendar Table in Power BI using DAX Functions with Enterprise DNA. We help you develop expertise in Power BI and use it to improve your business’ productivity. Join our course today.

    ReplyDelete
  15. This comment has been removed by the author.

    ReplyDelete
  16. When you are eager to hire one from our agency then give us the chance to provide the most elite independent models and highest rated Escort Service in Delhi for your best moments in life when visiting Delhi

    ReplyDelete

Post a Comment