Help in Applying a Customer Rebate when % Discount is in the Customer Dim Table

[Anonymous]

 Hi All

Can you not upload a sample PBIX to the board to make it easier to explain the issue.

Hopefully you can help with an issue I am having.  This is a cut down version of my model which has a Sales table of 50 Million Records.

I have a Net Sales measure which is Sum Sales - Sum of Credits and I want to take of a % Rebate to give me Net Sales After Rebate.  The % Rebate that the Customer gets is held in the Customer Table and is Called NPCusRebate.  The Rebate Total Method below does work but the performance is dreadful and I was hoping one of the Superstars on the Board could help me with a better solution.

Thanks

Chris

Model

Measures

Sales = CALCULATE(SUM(FactSales[Amount]))

Credit = SUM(FactSales[Credit Amount])

Net Sales = [Sales] - [Credit] +0

Rebate Total =

SUMX(

SUMMARIZE(

Customer,

Customer[CustomerID],

"NetSales", [Net Sales],

"Discount", [Rebate Selection]),

[NetSales] * [Discount])+0

Rebate Selection = IF( HASONEVALUE( Customer[NPCusRebate] ), VALUES( Customer[NPCusRebate] ), 0 )

Net Sales After Rebate =

IF(ISBLANK([Net Sales]),[Net Sales], [Net Sales]- [Rebate Total])

Results

[Greg_Deckler]

It's a permissions thing with the upload. Most people share out the PBIX with OneDrive, Box, etc.

[Anonymous]

Thanks  for the reply Greg

https://drive.google.com/open?id=1OpBgw8Dj2LrjSB9lA5EVugsdowycWKve