I am relatively new to using power BI, and am trying to apply weights to survey data.
The way the data is structured I have weights aligned with the corresponding userID's (my key)
What is the best way to apply this weight for each and every question I am visualising, and how is it done?
I have found the following resource for Tableau which looks like what I want: http://www.datarevelations.com/working-with-weighted-survey-data.html
How would I go about applying that in Power BI? I assume its converting this statement:
SUM([Weight]) / TOTAL(SUM([Weight]))
to PowerBi equivalent and adding it as a measure / in every visualisation?
Check out the on demand sessions that are available now!
Check out the Winners!
Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.