Forum Discussion
Anonymous
6 years agoNot applicable
Sales Filtering by a Measure
Hello Everyone, Firstable, thank you in advance for help. I will to be the more clear as I can. Here the context. I need to calculate the sales per group of stores which are rattached to a warehou...
Anonymous
6 years agoNot applicable
Hi lc_finance
Thanks for answering. I attached the PBI
In my example, I have the total quantity sold equal to 1200 pieces for 1 product. But I need the quantity sold by BU.
I need to see 500 pieces for Europe and 700 pieces for America. We have to take into account that my data are built exactly as the PBI I attached. therefore, I can't add a product type in my sales table. (Which is in reality a carton bar code).
I hope this time, it will be more clear.
Thanks in advance,
Here the document : Link to PBI
Erwan
lc_finance
6 years agoSolution Sage
Hi Anonymous ,
it looks like the link to the Power BI file is not a public link so I cannot access it.
You could check if it's possible to make it public?
Regards
LC