Aggregated values directly at the last rows of TABLE visuals

[InsHunter]

Hi,

Being a newbie requesting help to get the aggregated values below the "total" row generated from TABLE visual. Unable to use MATRIX visual as i need to show the aggregated values below the total(sample representation as below).Will use the same for Date wise as well as month wise ,year wise slicer.

Data Set Sample as below:

Also i have created Aggregated Table using Power query which is available as a data set:

Also have created measures on values  for each measuing point separately which is used for other graphical visuals.

Deeply appreciate forums support to meet the objective. Thank you.

[v-yiruan-msft]

Hi  @InsHunter ,

Please review the following links and check if they can help you get one solution:

1. Create Inforiver visual:

Insert row and manually enter data in Power BI matrix reports

2. By using ROW function:

Add new row with accumulate in Matrix

Table = UNION(VALUES('Sales'[Product]),ROW("Product","XMonth Accumulate"))

Looking for difference between two values by filters

Best Regards

[InsHunter]

Hi,

Thanks for the same. I tried the custom visual but the "Insert Row" is not being shown when I select this visual.

Thanks

[v-yiruan-msft · Accepted solution]

Hi @InsHunter ,

Which custom visual you are creating? Is it Inforiver Enterprise Matrix / Table? If yes, you can see the option "Insert" just as below screenshot.

And you can try the other methods which I refer in my previous post:

By using ROW function:

Add new row with accumulate in Matrix

Table = UNION(VALUES('Sales'[Product]),ROW("Product","XMonth Accumulate"))

Looking for difference between two values by filters

Best Regards

[amitchandak]

@InsHunter , You can not add additional totals, but you can have min/max using isinscope

if(not(Isinscope(Table[Date])) , [Max Meausre], [Measure])

https://www.kasperonbi.com/use-isinscope-to-get-the-right-hierarchy-level-in-dax/

[InsHunter]

@amitchandak 
Hi. Thanks for your response. If further support can be given it will be helpful as i could not make much out of this. Deeply appreciate your help.