Q&A Percent Not Working (ALL Function)

[kehamilton92]

I am calculating % of a total (Share), and want my numerator to be dynamic based on filters.  This calculation works when I put it in a table, but does not work when I ask about it in the Q&A visual.  See example below.
The Share Calculation:

The results:

The best I can guess is that the ALL function is not working properly.  Does anyone know why this is happening or have a workaround?

Thank you,

Katie

[kehamilton92]

For context, this works correctly when I use ALL to reference the entire Products table rather than specific columns.  Not sure if this is a glitch.

[v-yuta-msft]

@kehamilton92 ,

This is because the columns is in a different table, put [Color] and [Sales] in the sales table, Q&A could work as below:

 

Regards,

Jimmy Tao

[kehamilton92]

@v-yuta-msft  actually, this was a glitch with the June version.  As soon as I updated to the July version of the desktop client, this issue was fixed, no changes needed!