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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
jrscaletta
Helper II
Helper II

Measure percent by cattegory

Hi all.

 

I have a data table that have:

 

User --- Hours -- Cattegory

----------------------------------

Dan --- 3 --- Support

Ane --- 4 --- Project

Dan --- 5 --- Project

Ane --- 4 --- Support

 

Then, total hours by user are 100%.

How can I obtain % to support and % to Project, like this:

 

Ane - 50% Support - 50% Project

Dan - 37.5% Support - 62.5% Project

 

Thanks in advance. 

2 ACCEPTED SOLUTIONS
vivran22
Community Champion
Community Champion

@jrscaletta 

 

Hi,

 

There are two approach for it. Please refer to the pbix file here

 

In the first table matrix, I have used the % of row total option.

 

In the second table matrix, I have used DAX to calculate the required value.

 

Hope this helps.

 

Rgds,

Vivek

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Anonymous
Not applicable

Create following column 

Percentage= (Divide(Hours, 4))*100

or you can use option from modelling % this symbol.

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

Create following column 

Percentage= (Divide(Hours, 4))*100

or you can use option from modelling % this symbol.

vivran22
Community Champion
Community Champion

@jrscaletta 

 

Hi,

 

There are two approach for it. Please refer to the pbix file here

 

In the first table matrix, I have used the % of row total option.

 

In the second table matrix, I have used DAX to calculate the required value.

 

Hope this helps.

 

Rgds,

Vivek

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
March Fabric Community Update

Fabric Community Update - March 2024

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

Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.