cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
bugs777
Frequent Visitor

Dynamic measure based on microsoft forms input

 

Hi,

I'm building a dashboard which displays the outputs of a survey which is completed via microsoft forms. 

I have a power automate flow set up such that when responses are receieved, they are pushed to an excel which is connected to this dashboard. 

 

Now on this dashboard, for a given visual, I'd like to introduce a target value showing how that client measured up against everyone else who filled out the survey - however I would like for this derived measure to be calculated automatically based on the responses submitted in microsoft forms.

 

To give an example lets say company x fills out this survey and their company name, x, is included in the response form. I then have a guage visual which gives an average score for let's say environmental policy across all companies who filled out the form. I want to display company x's score for environmental policy on this same visual automatically when their reponse is pushed to the excel so that this can then be mailed back to them.   

 

Any advice on how I might approach this?

 

Thank you in advance!

 

2 REPLIES 2
amitchandak
Super User IV
Super User IV

@bugs777 , not very clear to me, but see if power app can help you

https://www.youtube.com/watch?v=LxuRzj0X348



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

v-shex-msft
Community Support
Community Support

HI @bugs777,

>>for a given visual, I'd like to introduce a target value showing how that client measured up against everyone else who filled out the survey - however I would like for this derived measure to be calculated automatically based on the responses submitted in microsoft forms.

I think you need to design a user mapping table to mao records with username, then you can write measure formula with 'username' function to get current user records dynamically and compare with of total users records.

USERNAME 

Using Username() in DAX with Row-Level Security 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

Top Solution Authors
Top Kudoed Authors