undefined

[ZOEY]

Hello Friends,

situation:  see below, image 1 displaying the relationship:

image 2 display the table and pivot table:

image 3 shows i selected the category ID from table categories.. 

i really don;t understand why my pivot table display all product for  category 1, same for category 2 and 3? can someone please help?

i tried with different data model, came back the same result.. .. 

thank you in advance.. Zoey

[danextian · Accepted solution]

Hi @ZOEY ,

I seldom use Power Pivot but, based on experience, that is how it behaves. Adding an aggregation to  Value should fix that.

[ZOEY]

@danextian you are right.. it only works with a value field input! This is a big lesson thank you !!!

I thought I have issue with bugs or setup not correct. 

Thank you! 

Zoey

[amustafa]

Hi @ZOEY 

See the sample Excel file with Power Pivot and Power BI file using your sample data. All products aligns with catogories. Use the link below to download the files.

Product Categories

If I answered your question, please mark this thread as accepted and Thums Up!
Follow me on LinkedIn:
https://www.linkedin.com/in/mustafa-ali-70133451/

[ZOEY]

@amustafa Thank you.. I did not know it only works with value field input. 

thank you

Zoey