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
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.