topic Re: need help dax (it's urgent) in DAX Commands and Tips

need help dax (it's urgent)

Nihed — Wed, 23 Feb 2022 11:07:16 GMT

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 — Wed, 23 Feb 2022 11:24:12 GMT

Nihed, see if this measure can help

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

Nihed — Wed, 23 Feb 2022 12:08:39 GMT

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

amitchandak — Wed, 23 Feb 2022 12:11:46 GMT

Nihed , Use an aggregations

example

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

Nihed — Wed, 23 Feb 2022 12:21:39 GMT

It seems to me it works well thank you 🙂