Percentage by grouped values

[Syndicate_Admin]

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.

[whitch]

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.