Total issue using measure ( Normal total and same total but inside the matrix)

[Anonymous]

Hi ,

I am faced an issue in my Matrix using a calculated measure. it is showing inside my rows a Total . which means that i Have a 'Normal' Total and another same Total is inside the matrix ( as row )without label.

I have two tables (realized  income and costs , Budget)  I have a period field in both tables.

I created a key to link both tables ( key is the concatenation between the period , group and sub group )

here the measure that causing a ' double Total' in my matrix . ( I tried to use a  formula with Time inteeligence here SAMEPERIODLASTYEAR but it doesn't work  with filter context ) 

Thank you 

[Anonymous]

Hi @amitchandak   , 

Attached here a sample data . i have two views one for realized income and cost and another one for Budget. here we are trying to compare what we realized and what it was done through budget table inside the pbix. sorry i can't share the pbix as they are a lot of sensitive data but i shared a matrix . the dashboard is a filter based on Period which is coming from Budget table . matrix contains Groups and subroup account with their Balance. and the calculated measure is like the budget same priod last year . idem for Realized amount. I shared a quick sample of data . The link between two views in pbix is the KEY_BUDGET and KEY_REALIZED. which is a relation 1 to many  ( from budget to realized income and cost).
the issue here is that i have inside my matrix a calculated total twice as mentionned. it may coming from my calculated measure.

thank you for helping

relized income view :

Budget view 

[amitchandak]

@Anonymous ,
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.