Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
2 years ago

Percentage by grouped values

Hello everyone,

I would like to calculate the percentage of occurrence of a value (in this case of "dedicated") by country and type of business

How can you see that would be the structure of the table, now:

From the previous column tipo_base_transporte2 I would like to calculate what percentage of "non-dedicated" or "dedicated" occurs by business and country of origin.

Thank you.

1 Reply

  • whitch's avatar
    whitch
    Resolver I
    2 years ago

    Perhaps something is lost in translation, but this seems relatively easy.  Assuming your table is called 'Table1', then create the following measures:

     

    %Dedicado = CALCULATE(COUNTROWS('Table1'),'Table1'[Tipo _base_transpote_2] = "dedicado")/COUNTROWS('Table1')
     
    %nonDedicado = 1 - [%Dedicado]
     
    Create a matrix visual, put above measure in the values section and business / country of origin in rows / columns.