How to show count of completed surveys using Unpivoted Table

[Last_Resort_22]

I have a matrix that references an unpivoted table containing survey information. I created an attribute alias that allows me to rename and use specific questions from the survey and use them as a slicer which also allows me to create a dynamic average total that changes depending on which attributes/questions matter to them.
I want to display the count of reviews given for each company but I'm having trouble getting it to just appear one time in the matrix. I dont want a row for each question. asked and I don't want to group the review count into the average measure because I don't want it to affect their score. Any tips would be appreciated. Thanks

[v-pnaroju-msft · Accepted solution]

Thankyou, @Ashish_Mathur, @Shahid12523 for your responses.

Hi Last_Resort_22,

We appreciate your inquiry submitted through the Microsoft Fabric Community Forum.

Based on my understanding of the issue, please find attached a screenshot and a sample PBIX file that may help resolve the problem:

We hope the information provided is helpful. If you have any further queries, please feel free to contact the Microsoft Fabric community.

Thank you.

[Shahid12523]

To show the count of completed surveys just once per company in a matrix with unpivoted data:

CompletedSurveyCount =
CALCULATE(
DISTINCTCOUNT(SurveyTable[SurveyID]),
REMOVEFILTERS(SurveyTable[QuestionAlias])
)

This avoids repeating the count per question and keeps it separate from your average score logic.

[Ashish_Mathur]

Hi,

Share some data to work with and show the expected result.  Share data in a format that can be pasted in an MS Excel file.