Hi I am learning Power BI and trying to understand how calculate works without filter calculate sum sales total amout why cant we give sum sales total amount

0 votes
related to an answer for: Understanding the DAX CALCULATE function
Sep 30, 2020 in Power BI by amitha
• 120 points
1,266 views

Hey @Amitha

Could you please post your workaround what you are trying to do? Do you have any dataset where you want to perform the DAX calculation?

1 answer to this question.

0 votes

Hello @Amitha,

The CALCULATE function is useful because it can modify the filter context of the Expression inside, as indicated by the n number of filter conditions specified by the user, according to these steps:

  • If the filter context specified by a filter condition already exists, it will override the already-existing filter context with the new one that’s been specified in the CALCULATE expression.
  • If the filter context does not exist, it will add a new filter context according to the filter condition specified.
answered Oct 1, 2020 by Roshni
• 10,520 points

Related Questions In Power BI

0 votes
3 answers

How do I get token using javascript API while trying to embed graphs using Power BI

Use ADAL.js that will give you an ...READ MORE

answered Jun 22, 2019 in Power BI by anonymous
4,153 views
0 votes
1 answer

I have a web API with basic authorisation and username and password. How do i connect to it in Power BI?

Hey, @There, I found your query is quite ...READ MORE

answered Oct 29, 2020 in Power BI by Gitika
• 65,910 points
3,038 views
0 votes
1 answer

Why should I shift from MS Excel to Power BI

There are a lot of advantages from ...READ MORE

answered Sep 26, 2018 in Power BI by Kalgi
• 52,360 points
479 views
0 votes
1 answer

How to categorize state, pin and city in power bi (Address)

After loading dataset, you can split in ...READ MORE

answered May 10, 2019 in Power BI by anonymous
• 33,030 points
2,922 views
0 votes
1 answer

How to sum a data table in Power BI?

It's a good practice if you avoid ...READ MORE

answered May 17, 2019 in Power BI by Avantika
• 1,520 points

edited May 17, 2019 by Omkar 7,070 views
0 votes
1 answer

How to show visualization (map) based on latitude and longitude points in power BI?

Follow the below steps: 1. Select the map ...READ MORE

answered Oct 18, 2019 in Power BI by anonymous
• 3,450 points
2,678 views
0 votes
1 answer

How to Create and use doughnut charts in Power BI?

Hey, To create a doughnut chart in Power ...READ MORE

answered Feb 6, 2020 in Power BI by Gitika
• 65,910 points
789 views
0 votes
3 answers

How to create final table based on Joins of two tables in power BI?

To do so, follow these steps: From the ...READ MORE

answered Dec 16, 2020 in Power BI by Gitika
• 65,910 points
53,516 views
0 votes
4 answers

How to combine multiple tables in power BI?

Click Advanced Editor and check if step #"Appended ...READ MORE

answered Dec 16, 2020 in Power BI by Roshni
• 10,520 points
69,316 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP