Forum Discussion
vytas
Helper I
Helper IPower Bi and Power Pivot different results on same model
Hello , I have data model in Power Bi. Connected same data model in Excel Power Pivot and getting different results. Model is simple 2 tables - Product an Product Sales. In...
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
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
amitchandak
Super User
Super Uservytas , Put sum(Sales Quantity) and check, I doubt power pivot showing 0 /blank value too
vytasI don't want sum quantites - i want to see every quantitie was sold by product as i see in Power BI Matrix.