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 in Power BI by amitha
• 120 points
83 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 by Roshni
• 6,190 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,088 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 in Power BI by Gitika
• 51,280 points
131 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
• 51,970 points
119 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 9, 2019 in Power BI by anonymous
• 32,490 points
629 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,500 points

edited May 17, 2019 by Omkar 3,426 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 17, 2019 in Power BI by anonymous
• 3,450 points
537 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 in Power BI by Gitika
• 51,280 points
201 views
0 votes
0 answers

How to create a new slicer to filter data by district manager in Power BI?

Can anyone create a new slicer to ...READ MORE

Feb 6 in Power BI by Roshni
• 6,190 points
294 views
0 votes
1 answer