Forum Discussion

KeithSuckling's avatar
KeithSuckling
Icon for Helper I rankHelper I
9 years ago
Solved

What is the %GT Quick Calculation really?

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?

Need Help
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    9 years ago

    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