Summarize in Matrix, Not Show Detail

[jaredseal]

I have a disconnected table that is creating an income statement of sorts for our team. I have measures for each row.  Some rows have detail that are only applicable  to expenses (GL Account), but is not needed for Revenue.  

When I get to my measure that gives me Cash Flow From Operations, it repeats all the GL Accounts where they exist.  I can collapse the level of detail, but that would be confusing to users.  Any ideas on how to adjust my DAX to be able to show a calculated subtotal without showing any detail that may be a row level in the Matrix?

ProblemLayoutMeasure on MatrixMeasure causing issue

[amitchandak]

@jaredseal , refer if this can help

https://www.burningsuit.co.uk/blog/2019/04/7-secrets-of-the-matrix-visual/

[jaredseal]

@amitchandak I cannot get  the matrix sub/grantotals to work because we are displaying informational items such volumes and prices.  So I am using a measure to calculate what the subtotal/grand total would show.  That measure is what is showing all the other row entires.

[v-lionel-msft]

Hi @jaredseal ,

You can refer to the practice similar to this.

MyMeasure2 = IF(HASONEFILTER(Table[Year]),
IF(SUM(Table[Amount])<1000,0,SUM(Table[Amount])-1000),
SUMX(FILTER(Table,[Amount]>1000),[Amount]-1000)
)

Dealing with Measure Totals 

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[jaredseal]

@Greg_Deckler   I tried following your example, but my problem remains.  Since I am displaying multiple types of information, I cannot use Matrix totals.  I am trying to calculate a subtotal, summation of data above, for the LOE section, but the subtotal is repeating all of the detail from the index column.  Any thoughts/tips?