• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Power BI - Divide by Category

Prakash M

New Member
Hello There,

My Apologize, if this is not the correct platform to ask for a query related to Power BI Dax measure.

I have a requirement to calculate No. of category divide by Employee Contribution.

Please refer attached excel for reference.

For e.g. In Category column we have count for "Apple" as 7 and Employee Contribution is 149, so I need a dax to get percentage for this i.e. 7/149=5%

Similarly: For grapes we see count as 15 and Employee contribution is 67, so the result will be 15/67=22%