Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe 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.
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.
Solved! Go to Solution.
This seems to work:
This is my sample dataset:
Thanks a lot CoreyP.
I've tried what you recommended to me but it doesn't work.
I created a tabla like this:
And I created a new column like this:
As you can see, the percentages are the same for every row.
Oh, mine is a measure, not a column.
User | Count |
---|---|
131 | |
74 | |
70 | |
58 | |
53 |
User | Count |
---|---|
190 | |
97 | |
67 | |
62 | |
54 |