cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
DAX_Learner07 Regular Visitor
Regular Visitor

percentage of column's total,not row wise percentage sum

Hi, 

I am trying to get simply percentageshown in excel,But in power BI,

It gives me different result.Power BI  adds up row wise calculated percentage values.

 

 

 

per.PNG

1 ACCEPTED SOLUTION

Accepted Solutions
DAX_Learner07 Regular Visitor
Regular Visitor

Re: percentage of column's total,not row wise percentage sum

Hi,

Thank you for your suggestion.

I found one similar thread and it solved my problem




https://stackoverflow.com/questions/52087428/divide-using-totals-in-power-bi-cost-per-fte


 

2 REPLIES 2
ZunzunUOC Member
Member

Re: percentage of column's total,not row wise percentage sum

Hi @DAX_Learner07 , you could create a calculated column with this code:

 

Perc = DIVIDE(Percentage[first];Percentage[second])*100

 

Best Regards,
Miguel

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

DAX_Learner07 Regular Visitor
Regular Visitor

Re: percentage of column's total,not row wise percentage sum

Hi,

Thank you for your suggestion.

I found one similar thread and it solved my problem




https://stackoverflow.com/questions/52087428/divide-using-totals-in-power-bi-cost-per-fte


 

Helpful resources

Announcements
Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Power BI Helps Homeless and Trouble Youth

Power BI Helps Homeless and Trouble Youth

We spoke with Power BI Super User, Greg Deckler, about his charity work

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 275 members 2,918 guests
Please welcome our newest community members: