cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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
Highlighted
Community Support
Community Support

Re: Dynamic measure based on microsoft forms input

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 it as the solution to help the other members find it more quickly.
Highlighted
Super User IV
Super User IV

Re: Dynamic measure based on microsoft forms input

@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!!
My Recent Blog -Week is not so Weak Connect on Linkedin

Proud to be a Super User!

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Upcoming Events

Upcoming Events

Wondering what events you could join or have an event to promote yourself? Check out our Upcoming Events.

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

We are thrilled to announce we will begin running a monthly webinar series named Power BI Dev Camp.

Top Solution Authors
Top Kudoed Authors