Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
DimaMD
Solution Sage
Solution Sage

Calculate the actual weight in a single unit of measurement

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.

Screenshot_13.jpg

 

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


__________________________________________

Thank you for your like and decision

__________________________________________

Greetings from Ukraine

To help me grow PayPal: embirddima@gmail.com
1 ACCEPTED SOLUTION
VahidDM
Super User
Super User

Hi @DimaMD 

 

Try this measure:

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

 

Output:

 

VahidDM_0-1636412492894.png

 

 

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

Appreciate your Kudos!!

 

View solution in original post

2 REPLIES 2
VahidDM
Super User
Super User

Hi @DimaMD 

 

Try this measure:

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

 

Output:

 

VahidDM_0-1636412492894.png

 

 

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

Appreciate your Kudos!!

 

Hi, @VahidDM 
Thanks, this is a good solution.


__________________________________________

Thank you for your like and decision

__________________________________________

Greetings from Ukraine

To help me grow PayPal: embirddima@gmail.com

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.