Forum Discussion
Jo_Chrq
Helper I
Helper IDistribution of a variable in matrix
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: Store Table, linked with Stock Tab...
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.
v-zhangti
Community Support
Community SupportHi, 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.
Jo_ChrqIt's exactly what I need !
Thanks a lot