Add custom row to Table/matrix visual based on slicer

[Anonymous]

Hi,  I've a requirement from users to add a row at the end of Matrix visual for 'Other/Misc' if the slicer is selected as you see in the box.

'Other/Misc' data is also available in separate table by only Year, with SaleType as UNK, and Make also UNK 

I created SalesAgg table with combination of Fact table and 'Other/Misc' data using UNION and Summerize.

and from SaleType and Make slicers I've filtered this UNK (Unknown default) as users doesnt want to see.

So now how do I add Ohter/Misc row to the matrix when its checked by ignoring UNK filter in both 'SaleType' and 'Make' tables.

I create separate/Disconnected table just for Slicer with one column and one row.

[amitchandak]

you can use summarize and union to do that. But I not sure how to get total before Misc.

Balance Sheet = union(SUMMARIZE(Sales,Sales[Brand],"Col1",sum(Sales[Sales]),"Col2",sum(Sales[COGS]),"sort",COUNTROWS(Sales)),SUMMARIZE(Sales,Sales[Brand],"Col1",sum(Sales[Sales]),"Col2",sum(Sales[COGS]),"sort",COUNTROWS(Sales)),DATATABLE("Area",STRING,"Col1",DOUBLE,"Value",DOUBLE,"Clo2",DOUBLE
,{
{"    ",0.0,0.0,10000}
}
) )

Datatable is to add some statics data

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks.

[Anonymous]

Thank you @amitchandak 

I did this step.

Now my next step is displaying on the report based on slicer selection. am still looking for solution.

https://1drv.ms/u/s!Ai0GzdHCLgzPkn-A21nhmXwYmGtz?e=JaEawH

am attaching power bi file and spreadsheet.

[amitchandak]

Please check Edit Interaction under Format Tab, I found Interaction has been stopped. It should be like give below.

https://www.dropbox.com/s/8yafsuybvvsp2bb/Retail_PBIRS.pbix?dl=0

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks.