topic Re: Calculate the actual weight in a single unit of measurement in DAX Commands and Tips

Calculate the actual weight in a single unit of measurement

DimaMD — Mon, 08 Nov 2021 15:27:21 GMT

Hello my friends! Need your help.

I have 1 table, which consists of following collums: units (shops), product quantity, ID product; and second table: ID product, Weight

From 1 table we have already counted quantity of goods per unit.

The task is to count final quantity of goods in one unit (kg), while we have several of them. We need to do this by multiply quantity of goods (counted from 1 table) and weight (from table 2) that meets ID of product unit (from table 1).

We were able to accomplish that, but the problem is we have some units, that dont have weights, but in the same time we need to count quantity of them as well.

So in result we need to see (as in example) 9374,02 in units "pych." and 1739 in units "pack", the summary must be 9374,02+1739=11113

Exempl PBX

Re: Calculate the actual weight in a single unit of measurement

VahidDM — Mon, 08 Nov 2021 23:01:43 GMT

Hi DimaMD

Try this measure:

KG = if(ISBLANK([Weight]),[Quantity of goods],[prod.Quantity]*[WeightKG])

Output:

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

Appreciate your Kudos!!

Re: Calculate the actual weight in a single unit of measurement

DimaMD — Tue, 09 Nov 2021 07:06:54 GMT

Hi, VahidDM
Thanks, this is a good solution.