Forum Discussion
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 PowerBi i get result i want - under product just sales quantities from that product, but in Power Pivot it is different - seems like there is no connection between tables , why ? (Implicit , explicit measures ? )
Power BI Matrix report (no explicit measures created)
Power Pivot Report
Thank You in advance.
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
4 Replies
- amitchandak
Super User
vytas , 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.
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.
- vytas
Solution in Power Pivot Forum - https://techcommunity.microsoft.com/t5/excel/data-model-relations-not-working-properly-in-power-pivot/m-p/2689568#M111696
