Forum Discussion
Helper IWhy is value displaying as sum instead of specific value?
Would it work to change [Item Cost (2)] to a measure like this?
Item Cost (3) = SELECTEDVALUE(Product[Cost])
This way, if all of the products with the same Product Number cost the same, you'll get one value for cost.
If they have seperate values, how should PowerBI know which one to use for each Product Number? If this is the case, I would suggest adding cost as a secondary row, and pressing the "Expand all down one level in the hierarchy" button on the matrix to display them all.
the missing sigma sign is because the default summarization is set to don't summarize, if you set it to sum or another option it would re-appear. I have done a quick recreation and for the same column, in a matrix visual there is no 'don't summarize' option, however in a tabke visual it is there. if the way your data is shaped allows for it, you may want to try to use a table instead of matrix and see if selecting Don't Summarize helps.
Helper IUnfortunately a table won't really work for this case, as I need dates in the olumns and there are too many products and sales instances for a table to be fucntional. Thank you for your suggestions though!
I see. could you share some screen shots if the visual and the data you're working with, or something similar? would be a lot of help to udnerstanding all the moving pieces.
- msl924
Here's an example. I'm actually calculating cost, not price/revenue.
- "Count of Cost" is the cost column in my price list. This can also show up as sum, avg, min, etc. if I change the calculation method by right clicking the field
- "Item Cost 2" is a temporary measure I have that is calculated using data in my forecast sheet. However, I would like to avoid this option as the costs change and I want to update the cost/price table as opposed to the forecast data.
I don't necessarily want my item cost to appear in a column in this matrix, I just need a way to refence the specific cost value so I can multiply it by the forecast and actual quantities. Anytime I attempt this I end up with a sum of all the costs * the sum of all the products.
- Cmcmahan
Resident Rockstar
Would it work to change [Item Cost (2)] to a measure like this?
Item Cost (3) = SELECTEDVALUE(Product[Cost])
This way, if all of the products with the same Product Number cost the same, you'll get one value for cost.
If they have seperate values, how should PowerBI know which one to use for each Product Number? If this is the case, I would suggest adding cost as a secondary row, and pressing the "Expand all down one level in the hierarchy" button on the matrix to display them all.