Forum Discussion
Sales excluding Riesling product
Hey,
I'm trying to create a measure that calculates the total sales excluding the product Riesling.
However, when I put the measure into a card it's giving me the overall figure which still includes Riesling.
Any modifications to my code that will fix this? Code is below.
Thank you in advance.
13 Replies
gbarr12345 , Table should already be joined,
You can try like
Sales excluding Riesling =
CALCULATE(
COUNTROWS('Module Sales with Inventory'),
FILTER(
'Dimension Item',
'Dimension Item'[description] <> "Riesling"
))Hi Amit,
Thank you for the response.
I tried your code and it still seems to be appearing to show the sales but including the Riesling sales.
Is there any tweak to fix this?
Hi,
Share some data to work with, explain the question and show the expected result. Share data in a format that can be pasted in an MS Excel file.
Hi Ashish,
Essentially I'm looking to show all the sales between a TIME period excluding a certain product in this case it's Product B from the sample data below that I want to exclude.
I have sample data below pasted. I would like to have an outcome similar to the screenshot attached also if possible.
Dimension_Period Table FYPeriod 20240301 20240302 20240303 20240304 20240305 20240306 20240307 20240308 20240309 20240310 20240311 Dimension_Customer Table Customer Name 1 2 3 4 5 6 7 Dimension_Item Table Item A B C D Sales Table Sales 100 125 150 112 124 178 112 135 123 121 How can the sales table have just a single column?
