Forum Discussion

Andrew_SSFM's avatar
Andrew_SSFM
Frequent Visitor
7 years ago
Solved

Do not sum certain columns in matrix. Show values based on filter level?

Hello All!   I have some project data coming from two different tables and one of those tables (Project) has values (Fee, Complete) that should not be summed.  All values are attached to a 3-tier w...
Need Help
  • d_gosbell's avatar
    d_gosbell
    7 years ago

    Actually if you fix the syntax errors in my previous code the same approach will work for both the fee and pcnt (assuming that the row with the blank WBS2 is a total row so it should be shown for the WB1 line and hidden as a WBS2 line

     

    Fee Amt =
    IF( HASONEVALUE(Data[WBS2])
       ,CALCULATE(SUM(Data[Fee]), FILTER(VALUES(Data[WBS2]),Data[WBS2] <> ""))
       ,CALCULATE(SUM(Data[Fee]),Data[WBS2] ="" )
    )
d_gosbell's avatar
d_gosbell
Icon for Super User rankSuper User
7 years ago

Actually if you fix the syntax errors in my previous code the same approach will work for both the fee and pcnt (assuming that the row with the blank WBS2 is a total row so it should be shown for the WB1 line and hidden as a WBS2 line

 

Fee Amt =
IF( HASONEVALUE(Data[WBS2])
   ,CALCULATE(SUM(Data[Fee]), FILTER(VALUES(Data[WBS2]),Data[WBS2] <> ""))
   ,CALCULATE(SUM(Data[Fee]),Data[WBS2] ="" )
)
Andrew_SSFM's avatar
Andrew_SSFM
Frequent Visitor
7 years ago

Hey d_gosbell , 

 

It does look like your measure is what I'm looking for!  Thank you for your help :)

  • bachPBI's avatar
    bachPBI
    New Member
    7 years ago

    Hi All! 

     

    Is it possible to keep certain rows visible in a matrix but exclude their values in the matrix subtotals? Basically, I have an income statement with line items I do not want to include in totals but would like to keep their amounts visible in the matrix. Is this possible?

     

    Thank you for any and all help!