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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

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
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors