topic Re: Aggregated values directly at the last rows of TABLE visuals in DAX Commands and Tips

Aggregated values directly at the last rows of TABLE visuals

InsHunter — Fri, 18 Nov 2022 02:01:37 GMT

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.

Re: Aggregated values directly at the last rows of TABLE visuals

amitchandak — Fri, 18 Nov 2022 04:13:30 GMT

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/

Re: Aggregated values directly at the last rows of TABLE visuals

InsHunter — Sat, 19 Nov 2022 01:37:03 GMT

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.

Re: Aggregated values directly at the last rows of TABLE visuals

Anonymous — Mon, 21 Nov 2022 09:21:30 GMT

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

Re: Aggregated values directly at the last rows of TABLE visuals

InsHunter — Mon, 21 Nov 2022 12:13:42 GMT

Hi,

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

Thanks

Re: Aggregated values directly at the last rows of TABLE visuals

Anonymous — Fri, 25 Nov 2022 07:52:56 GMT

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