Power Bi and Power Pivot different results on same model

Hi vytas ,

Since it is not a Power BI issue, you can go to the Power Pivot forum to consult.

From what I have learned, your Power Pivot table seems to lack a hierarchy. Please kindly refer to

https://support.microsoft.com/en-us/office/hierarchies-in-power-pivot-002cf883-3b5f-497c-bfa1-ab2271cdb73b

Best Regards,

Stephen Tao

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

Solution in Power Pivot Forum - https://techcommunity.microsoft.com/t5/excel/data-model-relations-not-working-properly-in-power-pivot/m-p/2689568#M111696