Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Calculate poor %

I currently have data like the following:

 

DateMeeting IDUserCountryLatencyPacket LossPoor?
27-Apr1BobUK5001%Poor
28-Apr2JamesUS1002% 
28-Apr2GillUS2506%Poor
30-Apr3BobUK503% 
30-Apr3MikeUS2001% 

 

And would like to produce the following:

 

Country# of Streams# of Poor% Poor
UK2150%
US3133%

 

The key part unsurprsingly is the poor percentage.

 

Thanks!

  • Phil_Seamark's avatar
    Phil_Seamark
    8 years ago

    HI Anonymous

     

    I added the following three calculated measures to  my model

     

    # of Streams = COUNTROWS('Table1') 
    # Poor = 
    COUNTROWS(
        FILTER(
            'Table1',
            'Table1'[Poor?]="Poor"
            )
           )
    % Poor = DIVIDE([# Poor],[# of Streams])

    Once I formatted the last one as a percent, I get this.

     

1 Reply

  • Phil_Seamark's avatar
    Phil_Seamark
    Microsoft Employee
    8 years ago

    HI Anonymous

     

    I added the following three calculated measures to  my model

     

    # of Streams = COUNTROWS('Table1') 
    # Poor = 
    COUNTROWS(
        FILTER(
            'Table1',
            'Table1'[Poor?]="Poor"
            )
           )
    % Poor = DIVIDE([# Poor],[# of Streams])

    Once I formatted the last one as a percent, I get this.