Power Bi Percentage year sales for each month

[Dicken]

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

[romperstomper]

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

[Dicken]

Yes, you do have it working, I still don't, I tried replacing the measure with Sum calculation within the measure but still not good,

Please Login or Register  to view this content.

still doesnt work, I can get it to give the correct result

with

Please Login or Register  to view this content.

in the copy you've attached I have got to work my self, I'm wondering if I'm doing something wrong with the date table?

Richard

[romperstomper]

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

[Dicken]

I'll have another go at sorting out what's happening and see how I get on.

At least I know it can work.

Richard.