Forum Discussion

TomasJochec's avatar
TomasJochec
New Member
8 years ago
Solved

Slicer changing total

Hello,    I would like to ask about slicers. I have Total value of warehouse in selling prices, buying prices, etc.  When I use slicer for category I get lower number of warehouse value = thats ri...
  • TomasJochec's avatar
    TomasJochec
    8 years ago

    Hi,

     

    so I found solution by myself. I had to make Column with TOTAL SUM in every single row. 

    *Product[C-WHTotalValueBuyPrice] ↓

    In other column I made SUM only for single product.

     

    Then in meassure I had to calculate witch part in percent is SUM from single product from TOTAL SUM.

    M-BuyPriceWarehouse= sum(Product[C-WHValueBuyPrice])/AVERAGE(Product[C-WHTotalValueBuyPrice])

    So When Product cost in Warehouse is 10 and TOTAL SUM of Warehouse stock cost is 100, I will get "0,1"  = 10 %

     

    Then I have to calculate opposit value = 90%, witch is second part in Pie chart.

    M-OppositeValue = (
         AVERAGE(Product[C-WHTotalValueBuyPrice])/AVERAGE(Product[C-WHTotalValueBuyPrice])-[M-BuyPriceWerahuse])
    )

    Then I can theese two meassures add to pie chart

     

     

v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
8 years ago

Hi TomasJochec,

 

Could you please mark the proper answer as solution?

 

Best Regards,
Dale

TomasJochec's avatar
TomasJochec
New Member
8 years ago

Hi,

 

so I found solution by myself. I had to make Column with TOTAL SUM in every single row. 

*Product[C-WHTotalValueBuyPrice] ↓

In other column I made SUM only for single product.

 

Then in meassure I had to calculate witch part in percent is SUM from single product from TOTAL SUM.

M-BuyPriceWarehouse= sum(Product[C-WHValueBuyPrice])/AVERAGE(Product[C-WHTotalValueBuyPrice])

So When Product cost in Warehouse is 10 and TOTAL SUM of Warehouse stock cost is 100, I will get "0,1"  = 10 %

 

Then I have to calculate opposit value = 90%, witch is second part in Pie chart.

M-OppositeValue = (
     AVERAGE(Product[C-WHTotalValueBuyPrice])/AVERAGE(Product[C-WHTotalValueBuyPrice])-[M-BuyPriceWerahuse])
)

Then I can theese two meassures add to pie chart

 

 

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft Employee
    8 years ago

    Hi TomasJochec,

     

    Thank you for sharing with us. The solution is very wonderful.

     

    Best Regards,

    Dale