Matrix calculation based on different fields

[talhaparvaiz]

Hi,

I am using matrix to display our survey results.

As you can see from the snapshot below, I am able to summarize results by applications where our survey responders provided the feedback. 

Now, I want to show the survey feeback against the total number of app users (this is to mainly determine the percentage of survey respondents against the actual application users) . Please advise how to achieve it

Here is the table structure for the reference.

thanks

[Anonymous]

HI @talhaparvaiz 

Create a new measure

_pcnt = Count(table[respondent id])/Average(table[total Users])

This should give you the expected output.

If it doesn't, Please share details aboy below fields like DAX statement, Summarization level.

[talhaparvaiz]

Is there a website where I can share my powerBI file for your review and feedback.

Thanks

[talhaparvaiz]

https://drive.google.com/file/d/1-xq_y63djhMOpmtRgtoD1UN_4mhI0D9S/view?usp=sharing

Here is the file

Thanks

[Anonymous]

HI @talhaparvaiz,

I'd like to suggest you write a measure with summary function and add raw categories, then you can add the second aggregate function to calculate with the raw result:

Measure =
SUMX (
    SUMMARIZE (
        Sheet1,
        [Application_Name],
        [Attribute],
        [Business Division],
        [Value],
        "rate", DISTINCTCOUNT ( Sheet1[Respondent_ID] ),
        "total", VALUE ( MIN ( Sheet1[Total_Users] ) )
    ),
    [Rate] / [total]
)

Regards,

Xiaoxin Sheng