Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello,
I am working with survey responses and would like to be able to calculate the average # of responses to each of the questions.... Example: How many respondents on average selected agree for question 1? I'm not seeing the option to add a new measure on the web version of power bi. I'm also only seeing the ability to choose count which isn't what I am looking for.
Does anyone have experience with calculating the average response for survey questions (Strongly agree to Strongly Disagree)? If so, how did you go about making those calculations. Is it something that needs to be done in a desktop version of power bi?
Thank you!
Solved! Go to Solution.
Hi , @eteynor
According to my research and testing, if you want to create measures in PBI service, you can try Datamart, a preview feature that PBI has released in the past six months, which allows you to connect to data sources, create measures, and apply them to corresponding datasets:
For more information, you can refer to :
Get started with datamarts (preview) - Power BI | Microsoft Learn
Thank you for your time and sharing, and thank you for your support and understanding of PowerBI!
Best Regards,
Aniya Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi , @eteynor
According to my research and testing, if you want to create measures in PBI service, you can try Datamart, a preview feature that PBI has released in the past six months, which allows you to connect to data sources, create measures, and apply them to corresponding datasets:
For more information, you can refer to :
Get started with datamarts (preview) - Power BI | Microsoft Learn
Thank you for your time and sharing, and thank you for your support and understanding of PowerBI!
Best Regards,
Aniya Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
You need to create measures using Power BI Desktop, or Tabular Editor to an XMLA endpoint if you have premium. You cannot do that in the web currently.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingJoin the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
55 | |
39 | |
33 | |
31 | |
25 |