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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

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
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

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