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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Anonymous
Not applicable

The percentage occurrence of the "dedicated" value for each business in each country.

Hi everyone!

 

I have a table with a column which shows two possible values ("Dedicated", "Non dedicated"), two another columns called "Origin country" and "Business" with many many rows. 

 

Now, I would like to create a new table which groups by country and business and show the percentage occurrence of the "dedicated" value for each business in each country.

 

diegomerino_0-1695895975376.png

 

1 ACCEPTED SOLUTION

Oh, mine is a measure, not a column.

View solution in original post

3 REPLIES 3
CoreyP
Solution Sage
Solution Sage

This seems to work:

CoreyP_0-1695971298385.png

 

This is my sample dataset:

CoreyP_1-1695971322140.png

 

Anonymous
Not applicable

Thanks a lot CoreyP.

I've tried what you recommended to me but it doesn't work.

I created a tabla like this:

 

diegomerino_0-1695973654859.png

 

And I created a new column like this:

 

diegomerino_1-1695973686557.png

 

As you can see, the percentages are the same for every row.

Oh, mine is a measure, not a column.

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

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