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
683 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,480 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
2,609 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,950 points
916 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,370 points
197 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,010 points
1,190 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 EdurekaUser
• 1,500 points

edited May 17, 2019 by Omkar 5,074 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
1,179 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,950 points
336 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,950 points
23,362 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,480 points
26,960 views