Forum Discussion

Sreerams26's avatar
Sreerams26
Frequent Visitor
3 years ago

Subtotal without calculation

I have two tables.  First table has product and warehouse wise price for various dates in current year and second table has the product and warehouse wise quantity as on date.  I had created a measur...
Need Help
v-zhangti's avatar
v-zhangti
Community Support
3 years ago

Hi, Sreerams26 

 

I simulated some data to hopefully match your situation. Please mainly look at the method.

[Lastest Price] is a measure.

Measure = SUM('Table'[Physical Inventory])*[Lastest Price]
Inventory Value = IF(HASONEVALUE('Table'[Unique item]),[Measure],SUMX('Table',[Measure]))

IF(HASONEVALUE()) can control the output of total.
 

Best Regards,

Community Support Team _Charlotte

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

Sreerams26's avatar
Sreerams26
Frequent Visitor
3 years ago

First of all, thanks for the response.  I am not sure if I did it correctly, still I am not getting the right response. Based on your suggestion, I made the necessary changes in the formula. The total in Group ASIA is reconciling howerver, none of the other groups match.  So wondering what could be missing?

 

Inv Value Measure = [Latest Price]*SUM('On hand Inventory'[OnHandQuantity])
Inventory Value = if(HASONEVALUE('Item price'[Unique item]),[Inv Value Measure], SUMX('Item price',[Inv Value Measure]))
  • v-zhangti's avatar
    v-zhangti
    Community Support
    3 years ago

    Hi, Sreerams26 

     

    Sample data:

    The formula does not change.

    If your results are inconsistent with expectations, can you provide more data?

     

    Best Regards,

    Community Support Team _Charlotte

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