Forum Discussion

ibach's avatar
ibach
Regular Visitor
10 years ago
Solved

How to create a calculated row in a matrix?

Hi,   I've tried searching for a solution to my question but I have not found an answer.  What I'm trying to do is to simply have a "calculated row" at the bottom of Matrix Visualization that I can...
Need Help
  • konstantinos's avatar
    konstantinos
    10 years ago

    Greg_Deckler ibach You can create a custom formula that evaluates the last Total row ( based on the filter context ) and changes the formula or leave it blank, depending what rows you have on matrix and what other cross filtering you will have..

     

    i.e   if you have months on rows you can change the grand total row with  a new measure like [Custom Income] = IF ( HASONEVALUE(Dates[Month]; [SumOfIncome] ; [Net Income])    or IF(COUNTROWS(VALUES[Dates[Month])>1.........)

     

     

     

     

     

     

Greg_Deckler's avatar
Greg_Deckler
Community Champion
10 years ago

Sounds like what you want is a measure with your formula in it and a Matrix visualization with your months as rows. Then you could have your measure as a column.

ibach's avatar
ibach
Regular Visitor
10 years ago

Thanks for the quick reply! :smileyvery-happy: So I would have to flip x & y around around.  Is that that only way you see something like this working with a Matrix visualization?  It would be nice to have it at the bottom if possible, but if not, it is what it is I guess.