need help dax (it's urgent)

[Nihed]

Hello,

Please I want to calculate % for each quarter and not percentage of total in the following visual.

what syntax is needed to do it in dax

[amitchandak]

@Nihed, see if this measure can help

divide([Headcount (M)], calculate([Headcount (M)], removefilters(Table[gender]))

[Nihed]

I have th field headcount culomn in my data not measure what should I do in this case

[amitchandak · Accepted solution]

@Nihed , Use an aggregations

example

divide(Sum(Table[Headcount (M)]), calculate(Sum(Table[Headcount (M)]), removefilters(Table[gender]))

[Nihed]

It seems to me it works well thank you 🙂