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.........)

     

     

     

     

     

     

konstantinos's avatar
konstantinos
Icon for Memorable Member rankMemorable Member
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.........)

 

 

 

 

 

 

Prathyush's avatar
Prathyush
Frequent Visitor
9 years ago

Hi did anyone find a Solution for this, I am also looking for a  way to add a calculated mesure in tha last row - after the grand total. then following rows will be my other calculations...

  • Prathyush's avatar
    Prathyush
    Frequent Visitor
    9 years ago

    Dear All,

     

    I am looking for a data visualization as below.

    DateSales
    01.04.201787,155.15
    02.04.201775,671.05
    03.04.201753,656.58
    04.04.201795,583.53
    05.04.201781,566.91
    06.04.201755,232.89
    07.04.201719,664.03
    08.04.201785,603.81
    09.04.201792,895.74
    10.04.201749,260.52
    11.04.2017110,258.68
    12.04.2017119,984.92
    13.04.201774,187.71
    14.04.2017 
    15.04.201780,569.64
    16.04.201789,012.01
    Grand Total1,170,303.16
    Total Budget2,500,000.00
    Difference-1,329,696.841

     

    How this can be achived in Power Bi Destop?

     

    Prathyush