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.

     

     

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

Hi Anonymous,

 

Firstly, as I know, there is subtotal value for matrix in Power BI.

 

Based on your formula, it seems that you have two tables at least. 

 

I'm a little confused about your scenario. If it is convenient, please share your data sample and your desired output so that we could help further on it.

 

Best Regards,

Cherry