Calculate percentage based on multiple rows of table

[Anonymous]

I have summarized table that I created through DAX from direct query table. It look like:

Name	Effort in days	Team
XYX	5	1
XYX	3	2
ABC	3	1
ABC	2	2

I need to create another column that tells me how much % of effort(of the total effort spent) a person spent in the team. So the output would look like:

Name	Effort in days	Team	Percent
XYX	5	1	63%
XYX	3	2	38%
ABC	3	1	60%
ABC	2	2	40%

I am fairly new to Power BI, please help.

Thanks

Anuj

[Jos_Woolley · Accepted solution]

Hi,

=
DIVIDE(
    [Effort in days],
    CALCULATE(
        SUM( [Effort in days] ),
        ALLEXCEPT(
            Table1,
            Table1[Name]
        )
    )
)

Regards

[Aditya_Meshram]

Percent = 
DIVIDE(
    SUM('Table'[Effort in days]),
    CALCULATE(
        SUM('Table'[Effort in days]),
        ALLEXCEPT(
            'Table',
            'Table'[Name]
        )
    )
)

[Jos_Woolley]

This is a Calculated Column, not a Measure, so it's not necessary to apply an aggregation to the Effort in days column in this case. 

Regards

[Aditya_Meshram]

Oh okay, so that is why. You made a calculated column while I was making a calculated measure. Sorry for the unnecessary reply. I would delete it if I had the option to.

Regards,
Aditya

[Jos_Woolley]

Hi Aditya,

"Fix" seems a touch strong! 🙂

From what I understand, the use of fully qualified references to columns within the same table is only "recommended" practice, not obligatory. As such, I would have to disagree that your version constitutes a 'fix' of mine.

Regards

[Anonymous]

Thanks a lot for quick solution