Power Bi Percentage year sales for each month

Hi,

I generally use power pivot, but would like to do this in power bi,

in PP I have a a simple measure to create the total 'sales' or whatever for each year, ;

Please Login or Register  to view this content.

but if I try and use the same measure in PBi, I just get the Sales measure figure returned,
I've tired various options, both Tables are linked to a date table with date, Year, year No. Month, Month No.

I've attached the workbook in which I've use and have a pviot table which is what i'd like to get in power bi table or matrix.

Since posting I have found that

Please Login or Register  to view this content.

Will give me a total for each year, what I would like to use with a slicer but not affect this as a denominator in a percentage, so
at the moment, this if I slice by cat "A", I would like the over figure for the year to remain the same, any suggestions?

Richard

Not sure what you did in PBI but it works fine here - see attached.

Since I don't have your pbix file it's hard to say where it is going wrong.