Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Average and Count in same Graph

I am not able to include sample files so I hope I can explain this correctly.  I have a table with a column that the responses can range amoung several different answers.  What I am trying to do is s...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    Hi Anonymous,

     

    I think you can enter to query editor to add a column to check type and filter your formula to calculate average of rows which 'isnumber' is 'true'.

     

    Sample:

     

    Query:

    = Table.AddColumn(#"Changed Type", "Isnumber", each try Number.FromText([Test]) is number otherwise false)

     

    Result:

     

    Regards,

    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi Anonymous,

 

You can try to use below measure to modify the total row to show average count:

AVG Count =
IF (
    COUNTROWS ( 'Sample' ) = COUNTROWS ( ALLSELECTED ( 'Sample' ) ),
    AVERAGEX (
        SUMMARIZE (
            ALLSELECTED ( 'Sample' ),
            [Response],
            "Count", COUNT ( 'Sample'[Response] )
        ),
        [Count]
    ),
    COUNT ( 'Sample'[Response] )
)

 

Regards,

Xiaoxin Sheng