Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

undefined

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 do...
Need Help
  • danextian's avatar
    danextian
    2 years ago

    Hi Anonymous ,

     

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

     

     

amustafa's avatar
amustafa
Solution Sage
2 years ago

Hi Anonymous 

 

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/

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

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

    thank you

    Zoey