Forum Discussion

adelmonte's avatar
adelmonte
Icon for Resolver I rankResolver I
4 years ago
Solved

Average measure in Matrix Table

Hi All,

 

I would like to have a matrix table showing the following:

Origin, Report Number, Nr. of Reports and

"Average of Number of Residues" (Total No of Residues/qs_report)

My "Average per Country" Table content:

I tried to create an average measure but it does show what I've planned:

Measure:

Average = DIVIDE(SUM('Average per Country'[Total No of Residues]), DISTINCTCOUNT('Average per Country'[qs_report]))

 

Regards,

Alex

 

Need Help
  • PVO3's avatar
    PVO3
    4 years ago

    Hi,

     

    Try something like this 

    SUMX(
        ADDCOLUMNS(
            SUMMARIZE('Table','Table'['qs report'],'Table'['no residents']),
            "C",
            DIVIDE('Table'['no residents'],DISTINCTCOUNT('Table'['qs report']))
        ),
        [c]
    )

3 Replies

  • PVO3's avatar
    PVO3
    Icon for Impactful Individual rankImpactful Individual
    4 years ago

    Hi,

     

    Try something like this 

    SUMX(
        ADDCOLUMNS(
            SUMMARIZE('Table','Table'['qs report'],'Table'['no residents']),
            "C",
            DIVIDE('Table'['no residents'],DISTINCTCOUNT('Table'['qs report']))
        ),
        [c]
    )
  • tamerj1's avatar
    tamerj1
    Icon for Community Champion rankCommunity Champion
    4 years ago

    Hi adelmonte 

    try simple AVERAGE function 

    Average =AVERAGE('Average per Country'[Total No of Residues])