Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi all,
Once again I need your precious help 🙂
I need to find the measure that helps me create the followinfg column:
Data model is like this:
In a matrix I have a first column with the quantity in stock per store and in a specific warehouse (all in store table)
Second column is the distribution of the sales per stores (Warehouse is not concerned)
Third (which I struggle with) is the amount in stock per store + the warehouse stock quantity, distributed in each store based on the sales ratio above
Many thanks in advance for your help,
Best
Jonathan
Solved! Go to Solution.
Hi, @Jo_Chrq
You can try the following methods.
Sample data:
Store Table:
Sales Table:
Measure:
Stock+Warehouse distrib =
Var _N1=SUM('Store Table'[Stock])
Var _N2=SUM('Sales Table'[Sales distrib])
Var _warehouse=CALCULATE(SUM('Store Table'[Stock]),FILTER(ALL('Store Table'),[Store]="Warehouse"))
Return
IF(_N2=BLANK(),BLANK(),_N1+_N2*_warehouse)
Is this the result you expect?
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @Jo_Chrq
You can try the following methods.
Sample data:
Store Table:
Sales Table:
Measure:
Stock+Warehouse distrib =
Var _N1=SUM('Store Table'[Stock])
Var _N2=SUM('Sales Table'[Sales distrib])
Var _warehouse=CALCULATE(SUM('Store Table'[Stock]),FILTER(ALL('Store Table'),[Store]="Warehouse"))
Return
IF(_N2=BLANK(),BLANK(),_N1+_N2*_warehouse)
Is this the result you expect?
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
It's exactly what I need !
Thanks a lot
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
96 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
88 | |
63 |