Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more

Reply
Syndicate_Admin
Administrator
Administrator

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

diegomerino_0-1695830722070.png

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

diegomerino_1-1695830764846.png

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 1
whitch
Resolver I
Resolver I

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.
 

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors
Top Kudoed Authors