Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Summarize in Matrix, Not Show Detail

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

Need Help

4 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      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's avatar
        v-lionel-msft
        Community Support
        6 years ago

        Hi Anonymous ,

         

        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.