Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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...
Need Help
lc_finance's avatar
lc_finance
Solution Sage
6 years ago

Hi Anonymous ,

 

can you share a sample Power BI file via DropBox, One Drive, Drive or another similar tool?

 

That will make it easier to help you.

 

Regards,

 

LC

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    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's avatar
      lc_finance
      Solution Sage
      6 years ago

      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

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi LC, 

     

    I did not think it was going to be so complicated haha

     

    Here the link : Link PBI

     

    Thanks again

    • lc_finance's avatar
      lc_finance
      Solution Sage
      6 years ago

      Hi Anonymous ,

       

      I checked it. When I use the column BU from the Sales table instead of the Order table, the matrix works well.

       

      I see that the formula for the BU name is :

      BU Name order = CONCATENATEX(
		    VALUES('Order'[BU]),'Order'[BU],", ")

      If you want to use it to split sales (and not orders) by BU, why not changing it to:

      BU Name sales = CONCATENATEX(
		    VALUES('Sales'[BU]),'Sales'[BU],", ")

      Let me know if it works,

       

      LC

      www.finance-bi.com