Forum Discussion

nicolast29's avatar
nicolast29
Icon for Helper V rankHelper V
2 years ago
Solved

Matrix with 2 level of aggregation

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 th...
Need Help
  • Daniel29195's avatar
    Daniel29195
    2 years ago

    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! 🙏

Daniel29195's avatar
Daniel29195
Icon for Community Champion rankCommunity Champion
2 years ago

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's avatar
    nicolast29
    Icon for Helper V rankHelper V
    2 years ago

    Hi

    So simple

    So beautifull

     

    Thansk a  lot

    Have a  nice day