Dynamic measure based on microsoft forms input

[Anonymous]

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!

[amitchandak]

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

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

[Anonymous]

HI @Anonymous,

>>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