Need help to make correct measure via DAX - Power BI

[Anonymous]

HI,

I need some help to get a fact correct.

Model:

All relations 1 - M

All Facts are kept in tabel "WMSORDERTRANS" (Lowest granuality) + Center of the Universe where all relations point into.

The Visualization wich gives a challenge:

Dimension:

Facts:

Formulas to facts:

The question is how do I get "MAKS CBM" to calculate correctly:

Max CBM => to calculate correctly, The idea was => related (‘ltm tblCarriers’, ‘ltm tblCarriers [Optimal CBM] * [How many trucks] - (The Related function does not work!)  

But the whised result should be as below =>

CarrierCarNumber       Hvor mange lastbiler      Prøve CBM       Beregning (Maks CBM)            =    Resultat (How many CBMs could optimally have been used )

2501                              17                                   127,30                17*127,30                                     =                            2.418,7 CBM

2502                              8                                    127,30                17*127,30                                      =                            1018, 4 CBM  

………..

Total                                                                                                                                                                                    3.437,1 CBM   

And not like now 516 * 2,192.39 = 1.131.272,15 CBM

CarrierCarnumber = Expresses the individual car type

Hvor mange lastbiler (How many trucks) = Expresses how many trips the truck has drive

Prøve CBM (Test CBM) = Expresses how many CBMs there can be on one car

I hope the above description is good enough or else please come back to me.

Looking forward to a postive answer 🙂

Jesper

[v-robertq-msft]

Hi, 

According to your description, I can’t roughly understand what’s your true requirement, I suggest you to shorten your explanation about your needs and give us some test data as short as possible to give you the targeted assistance.

Thank you very much!

Best Regards,

Community Support Team _Robert Qin

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.