Forum Discussion

KeithSuckling's avatar
KeithSuckling
Helper 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...
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

     

     

GilbertQ's avatar
GilbertQ
Super User
9 years ago

Hi KeithSuckling

 

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?

 

  • KeithSuckling's avatar
    KeithSuckling
    Helper I
    9 years ago

    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's avatar
      GilbertQ
      Super User
      9 years ago

      Hi KeithSuckling

       

      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)
  )
)
      • KeithSuckling's avatar
        KeithSuckling
        Helper I
        9 years ago

        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.