Totals based on product variants (dimensions)

[Anonymous]

Hi all, 

I am realitively new to to Power Bi and while I have managed to get my main "totals" measures sorted, Total Sales, Total QTY, etc, I have come unstuck when it comes to showing correct values at the product variant level (Configuration, size, Colour).

All my totals are based on the simple SUMX function i.e 

Total Sales = SUMX('Sales Table', 'Sales Table'[INVOICE AMOUNT $$]).

When using this measure and other similar ones they show correctly correctly at the product level, however, when variants are brought in the values seem to show at the higher product aggregation. 

What do I need to do to flesh this Measure out in order to achive the correct outcome? Calculate, Calculatetable, filter??

Thanks for your help in advance. 

Joe

[Greg_Deckler]

Difficult to say without sample data. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

It is almost like your other dimensions are not connected/related to your fact table?

[Anonymous · Accepted solution]

Thanks for the quick reply @Greg_Deckler , looks like I had my relationships all up the wop!!

It all seems to be working well now. 

[Greg_Deckler]

I had a feeling!!