Forum Discussion
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 ...
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.