kehamilton92's avatar
kehamilton92
Icon for Advocate I rankAdvocate I
6 years ago
Status:
New

Q&A Percent Not Working (ALL Function)

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....
Reports
v-yuta-msft's avatar
v-yuta-msft
Icon for Community Support rankCommunity Support
6 years ago

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

Completed Ideas