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
3 Comments
kehamilton92Advocate I
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-msftCommunity Support
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!