Forum Discussion

talhaparvaiz's avatar
talhaparvaiz
Helper I
5 years ago

Matrix calculation based on different fields

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.   ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

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's avatar
talhaparvaiz
Helper I
5 years ago

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

 

Thanks

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      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