Need help to make correct measure via DAX - Power BI

Anonymous — Wed, 20 Oct 2021 10:10:01 GMT

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

Re: Need help to make correct measure via DAX - Power BI

v-robertq-msft — Mon, 25 Oct 2021 09:11:14 GMT

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.

topic Need help to make correct measure via DAX - Power BI in DAX Commands and Tips

Need help to make correct measure via DAX - Power BI

Re: Need help to make correct measure via DAX - Power BI