Forum Discussion
What is the %GT Quick Calculation really?
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
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)
)
)
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.
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