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%
Thanks
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%
Thanks