Forum Discussion

brinky's avatar
brinky
Icon for Helper IV rankHelper IV
4 years ago
Solved

Get volume (multiplication)

Hello, I'm trying to get the volume sales as follow however I'm getting the wrong values. I'm using measure 2 to get the sales qty then I'm using measure 4 to get volume however volume values a...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi brinky ,

     

    Try this code.

     

    Measure 3 = 
VAR _Invoiced_QTY = 
CALCULATE(SUM(Combined_Sales[Invoiced_QTY_PU]),FILTER(Combined_Sales,Combined_Sales[Return_Reason] in {1,BLANK()}))
VAR _Volumn = CALCULATE(SUM(Volume[Volume]),FILTER(Volume,Volume[CSB_ID_Code] = MAX(Combined_Sales[CSB_ID_Code])))
RETURN
_Invoiced_QTY*_Volumn

     

    Result is as below.

    Best Regards,
    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi brinky ,

 

I think your [Measure 4] is based on [Measure 2] and related

I create a sample to have a test.

CombinedSales:

VolumTable_1:

I created a relationship between two tables by Category.

Measures are the same, it works well.

Firstly, please check whether [Measure 2] is correct.  You can add a calculated column by related function to get data from [Litres] in CombinedSales.

C_Litries = RELATED(VolumTable_1[Litres])

Or create a measure.

C_Litries = calculated(sum(VolumTable_1[Litres]),Filter(VolumTable_1,VolumTable_1[...] = max(CombinedSales[...])))

 And check whether [Litres]  part is correct.

 

Best Regards,
Rico Zhou

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Hi brinky ,

       

      Try this code.

       

      Measure 3 = 
VAR _Invoiced_QTY = 
CALCULATE(SUM(Combined_Sales[Invoiced_QTY_PU]),FILTER(Combined_Sales,Combined_Sales[Return_Reason] in {1,BLANK()}))
VAR _Volumn = CALCULATE(SUM(Volume[Volume]),FILTER(Volume,Volume[CSB_ID_Code] = MAX(Combined_Sales[CSB_ID_Code])))
RETURN
_Invoiced_QTY*_Volumn

       

      Result is as below.

      Best Regards,
      Rico Zhou

       

      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.