Matrix with 2 level of aggregation

[nicolast29]

Hi i have a matrix to create like this one 

The first aggregation is the sum of the H & F for each month

I know how to calculate this aggregation,see pbix below, but i didn't arrive to put them in the same matrix

bdese.pbix

Thanks

[Daniel29195 · Accepted solution]

@nicolast29 

is this what you want ? 

create a calculated column in the table feuil : 

salaire global = CALCULATE(count(Feuil1[Salarié]) ,  removefilters(Feuil1[Sexe]), REMOVEFILTERS(Feuil1[Type decontrat]), REMOVEFILTERS(Feuil1[Salarié]))

then drag and drop as follow : 

let me know if this helps .

If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🙏

[nicolast29]

Hi

So simple

So beautifull

Thansk a  lot

Have a  nice day