DAX for display average score, median score and %ile.

[Abhishek94]

Context:
We are running a Survey to collect stakeholder feedback for different members of  the Facilities team. Each facilities team member caters to stakeholders from different internal units like CLOUD, Analytics etc. This will be the database input to my Power BI dashboard. 

PowerBI Dashboard:

On selection of any one facilities team member from filter, I need to calculate which unit he/she caters to the most by checking which unit gave him the most feedback. 
Using 'only the records from this unit', I should then calculate aggregate scores of every facilities person (in a temporary table) and display average score, median score and %ile of the selected facilities person. An example is shown below.

Below is the sample of my data and what my dashboard should show.

-------------------------------------------------------------------------------------------------------------------------------------

My problem statement:

Once the facilities team member is selected from the slicer, Card 1 should calculate the average score of this person (Keeping Andy as an example).

Need help with the below DAX:

• DAX should be used to calculate which unit gave Andy the most feedback (In our example MKTG).
• Then DAX should create a temporary table of all facilities members average scores from MKTG. Each team member will have only one record.

• Card 2 & 3 should be Andys’ score from the temporary table.
• Card 4 & 5 the unit averages also from temporary table.

Could anyone share how to do this dynamically in Power BI using DAX irrespective of which facility member is selected.

Regards,

Abhishek

[lbendlin]

a powerbi dashboard where all customers are giving feedback scores

Power BI dashboards are not interactive.

Power BI has no reliable free way to capture user feedback and store that back anywhere.

You may need to reconsider your choice of tools.  (PowerApps, or Forms etc)

[Abhishek94]

Sorry I wasn't clear have edited the post to clarify. I am not collecting the data from PowerBI the survey will be seperate. 

Using the collected data as my database for the PowerBI dashboard need help to generate the cards shown in the visual

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...