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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

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
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.