Matrix calculation based on different fields

Question

Hi,&nbsp;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.&nbsp;&nbsp;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&nbsp;&nbsp;&nbsp;&nbsp;Here is the table structure for the reference.&nbsp;&nbsp;thanks&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

anonymous · Answer

HI&nbsp;talhaparvaiz&nbsp;
Create a new measure
_pcnt = Count(table[respondent id])/Average(table[total Users])
This should give you the expected output.
&nbsp;
If it doesn't, Please share details aboy below fields like DAX statement, Summarization level.

&nbsp;

talhaparvaiz · Answer

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

talhaparvaiz · Answer

https://drive.google.com/file/d/1-xq_y63djhMOpmtRgtoD1UN_4mhI0D9S/view?usp=sharing&nbsp;Here is the file&nbsp;Thanks

anonymous · Answer

HI&nbsp;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

Forum Discussion

Matrix calculation based on different fields

4 Replies

Related content

Dynamic Calculation Different Period

Matrix calculation Issue - DAX

Different Calculations

PowerBI - Matrix table, hide values used only for a visual calculation

Dynamic Row-Level Calculation in Matrix (Different Logic per Row) - Scalable Approach?