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, 

 

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