Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Matrix columns subtotal in Matrix

Hi,   I'm struggling now for a long time to add subtotals tot my matrix based on different columns.   I have three columns: FTE :  Average personnel per month Cost: Amount of Personnel costs pe...
  • Anonymous's avatar
    Anonymous
    7 years ago

    guys for trying to help.

    But luckily I were managed to do it by myself.

     

    I used the DAX formula =HASONEFILTER

     

    Formula: Measure =
    [FTE SumX] + SUM('Appendtable CTC'[Amount]) -
    IF(HASONEFILTER('GL Account Group'[Actual]),SUMX(SUMMARIZE(FTE,FTE[Employee],"Average1",FTE[FTE total]),[Average1]),[FTE SumX])

     

     

    With this HASONEFILTER in the matrix under FTE shows the right FTE hours and under total i don't sum up the FTE but only the Cost Recovery.

     

     

Anonymous's avatar
Anonymous
Not applicable
7 years ago

guys for trying to help.

But luckily I were managed to do it by myself.

 

I used the DAX formula =HASONEFILTER

 

Formula: Measure =
[FTE SumX] + SUM('Appendtable CTC'[Amount]) -
IF(HASONEFILTER('GL Account Group'[Actual]),SUMX(SUMMARIZE(FTE,FTE[Employee],"Average1",FTE[FTE total]),[Average1]),[FTE SumX])

 

 

With this HASONEFILTER in the matrix under FTE shows the right FTE hours and under total i don't sum up the FTE but only the Cost Recovery.

 

 

  • v-piga-msft's avatar
    v-piga-msft
    Resident Rockstar
    7 years ago

    Hi Anonymous,

     

    It's glad that you have found the solution.

     

    Please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

     

    Best  Regards,

    Cherry