Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe 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.
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
Solved! Go to Solution.
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!!
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!!
Hi, @VahidDM
Thanks, this is a good solution.
User | Count |
---|---|
20 | |
20 | |
14 | |
10 | |
8 |
User | Count |
---|---|
29 | |
28 | |
12 | |
12 | |
12 |