Hi Jon, Thank you for this video. I was wondering what would be the appropriate DAX formula if you would like to calculate “20” or the unique number of survey respondents automatically, especially if you have a continuously growing dataset that is constantly refreshed. Is there another way to set up this pivot table that uses tools like DAX?
Also, what if you wanted to see how many unique respondents chose both “Coffee” and “Tea”? How would you set up the pivot table to show that?
Hi Jon, Thank you for this video. I was wondering what would be the appropriate DAX formula if you would like to calculate “20” or the unique number of survey respondents automatically, especially if you have a continuously growing dataset that is constantly refreshed. Is there another way to set up this pivot table that uses tools like DAX?
Also, what if you wanted to see how many unique respondents chose both “Coffee” and “Tea”? How would you set up the pivot table to show that?
Thanks for your help!
Jordan