- Forums
- Get Help with Power BI
- Desktop
- Service
- Report Server
- Integrations with Files and Services
- Mobile Apps
- Developer
- DAX Commands and Tips
- Let's Talk Data
- Custom Visuals Development Discussion
- Community Support
- Welcome to the Community
- Community Feedback
- Community Help Blog
- Training and Consulting
- Dashboard in a Day
- EdX Specific Training Discussion Forum

Turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

- Microsoft Power BI Community
- Forums
- Get Help with Power BI
- Desktop
- Re: What is the %GT Quick Calculation really?

Topic Options

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

KeithSuckling

Regular Visitor

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

05-17-2017
05:11 PM

Using the %GT quick calculation and realising that I couldn't change the name of it, I tried to use the formula that is generally described as the replacement.

Percentage = SUM(TableName[MyColumn]) / CALCULATE(SUM(TableName[MyColumn]), ALL(TableName))

However, when I went to use a filter on my report page, I noticed that the formula did not deliver the expected result.

After quickly testing side by side the results of GT% quick calc and the above formula calcuation I worked out only the GT% quick calc was giving me the changed view of my data that I wanted.

Is there anyone who knows what the formula for GT% quick calc is exactly so I can mimic its behaviour in more situations?

Solved! Go to Solution.

1 ACCEPTED SOLUTION

Accepted Solutions

v-qiuyu-msft

Moderator

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

05-20-2017
12:34 AM

Hi @KeithSuckling,

As the measure use the ALL() function which returns all the rows in a table, or all the values in a column, ignoring any filters that might have been applied. It's expected that when you check different values from the slicer, the chart values will not change.

Regarding the "Percent of grand total", any filters include slicer, visual/ page/ report level filters will impact values.

In your scenario, you can use ALLSELECTED() function in the measure,

Measure 2 = SUM(Table1[Person count])/CALCULATE(SUM(Table1[Person count]),ALLSELECTED('Table1'))

Best Regards,

Qiuyun Yu

Community Support Team _ Qiuyun Yu

If this post**helps**, then please consider *Accept it as the solution* to help the other members find it more quickly.

If this post

6 REPLIES 6

GilbertQ

Super User

Re: What is the %GT Quick Calculation really?

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

05-17-2017
05:32 PM

What I complete the steps that you did I get exactly the same results between the Quick measure and the created measure.

I am unsure how yours is different?

Did I answer your question? Mark my post as a solution!

"Proud to be a

KeithSuckling

Regular Visitor

Re: What is the %GT Quick Calculation really?

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

05-17-2017
11:31 PM

@GilbertQ below is the pic that shows a replication of the problem. The data file is incredibly simple, the two fields are very simple as well. When the filter is used the output of the formula and the GT% quick calc is different.

GilbertQ

Super User

Re: What is the %GT Quick Calculation really?

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

05-18-2017
02:55 PM

Could I please ask you to try the following formula, and see if that resolves your issue.

DIVIDE( sum(Table1[Person count]), Calculate( sum(Table1[Person count]), ALL(Table1) ) )

Did I answer your question? Mark my post as a solution!

"Proud to be a

KeithSuckling

Regular Visitor

Re: What is the %GT Quick Calculation really?

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

05-18-2017
11:05 PM

Thank for trying @GilbertQ

I had tried this already and it hadn't worked.

The picture below confirms the new formula produces the same result.

v-qiuyu-msft

Moderator

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

05-20-2017
12:34 AM

Hi @KeithSuckling,

As the measure use the ALL() function which returns all the rows in a table, or all the values in a column, ignoring any filters that might have been applied. It's expected that when you check different values from the slicer, the chart values will not change.

Regarding the "Percent of grand total", any filters include slicer, visual/ page/ report level filters will impact values.

In your scenario, you can use ALLSELECTED() function in the measure,

Measure 2 = SUM(Table1[Person count])/CALCULATE(SUM(Table1[Person count]),ALLSELECTED('Table1'))

Best Regards,

Qiuyun Yu

Community Support Team _ Qiuyun Yu

If this post**helps**, then please consider *Accept it as the solution* to help the other members find it more quickly.

If this post

Highlighted
##

KeithSuckling

Regular Visitor

Re: What is the %GT Quick Calculation really?

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

05-23-2017
02:44 PM