Percentaje by month

[Anonymous]

Hi, I need to calculate the percentaje by month of the Hours in this table, at the moment i obtain the % by all table, how to do that?, Thanks by the help

[sanalytics]

Try this measure

Measure = DIVIDE(SUM('Table'[Hurs]),CALCULATE(SUM('Table'[Hurs]),ALL('Table'[Cilent],'Table'[Mnth])))

Regards,

sanalytcs

if it is your solution pease accept it as solution and please like

[Anonymous]

Is not working, i have one table 

[Anonymous]

Thanks by the help

[sanalytics]

Can you please provide some dummy data so that i can try

[Anonymous]

How to send you the pbix file?

[Anonymous]

Example Data

Month	Client	Hours
1	C1	3
1	C2	4
1	C3	6
1	C4	8
1	C1	9
1	C1	10
1	C2	2
2	C3	3
2	C4	5
2	C4	7
2	C2	8
3	C4	12
3	C2	34

[Fowmy]

@Anonymous 

Measure to calculate the % of Total Hours by Month:

% Hours By Month = 

DIVIDE(
    SELECTEDVALUE(Table1[Hours]),
    CALCULATE( SUM(Table1[Hours]) , ALLEXCEPT(Table1,Table1[Month]))
)

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube  LinkedIn

[Anonymous]

Thanks a lot now iw working!, but when i tried summarize the hours the measure show errors. Thanks al ot by the help

[Fowmy · Accepted solution]

@Anonymous 

If you are summarizing, use this method,

% By Month = 

DIVIDE(
    SUM(Table2[Hours]),
    CALCULATE( SUM(Table2[Hours]) , ALLEXCEPT(Table2,Table2[Month]))
)

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube  LinkedIn

[Anonymous]

Thanks a lot by the help

[Anonymous]

Thanks by the help