How to calculate the order total containing certain products (new dimension caused problem)

DAX DAX Calculations
1

Hi, @Melissa, Hope you are doing well. Months ago, you helped me create a measure to calculate the basket sales for certain product in campaign period. It was working fine if it only contain product SKU, however, when I add product name, it stops working. I tried many ways, but out of luck, could you please help me to review it and see if there is any solution.

image

Here is the PowerBI file.

Thanks a lot!

Mike

Order_Total3.pbix (209.3 KB)

2

Hi @Mike

I don’t know the background, but if you are expecting the same output add removefilters to Product Name

image
image1464×728 33.9 KB

1 Like
3

I hope that you are having a great experience using the Support Forum so far. We’ve recently launched the Enterprise DNA Forum User Experience Survey, please feel free to answer it and give your insights on how we can further improve the Support forum. Thanks!

4

@Rajesh That works, thanks a lot!

Mike