locked
All values showing up when selecting attributes from dimension RRS feed

  • Question

  • I have two dimensions:

    DimCustomer - CustomerID, name, etc
    DimProduct - ProductID, price etc
    FactOrderDetail - CustomerID, OrderID, OrderDetailID, ProductID

    When i drag CustomerName onto the pivot table, it shows ALL customers.
    When I then drag ProductName on to the pivot table, it does a cross join, links all Customers to All Products.

    I expected id only get a list of customers linked the products they bought, due to the relationship through the fact table. What am i doing wrong here?

    Friday, August 8, 2014 11:01 AM

Answers

  • You need to add a measure in the pivot to make the relationship effective.

    Something simple like this should work:

    RowCount:= COUNTROWS(FactOrderDetail)

    • Proposed as answer by greggyb Friday, August 8, 2014 2:50 PM
    • Marked as answer by winstonSmith Friday, August 8, 2014 3:14 PM
    Friday, August 8, 2014 2:30 PM
    Answerer
  • You need to add a measure in the pivot to make the relationship effective.

    Something simple like this should work:

    RowCount:= COUNTROWS(FactOrderDetail)

    That works, thanks!

    How come a measure such as TotalValue:=SUMX(product,product[Cost]) doesnt work?
    Friday, August 8, 2014 3:16 PM

All replies

  • You need to add a measure in the pivot to make the relationship effective.

    Something simple like this should work:

    RowCount:= COUNTROWS(FactOrderDetail)

    • Proposed as answer by greggyb Friday, August 8, 2014 2:50 PM
    • Marked as answer by winstonSmith Friday, August 8, 2014 3:14 PM
    Friday, August 8, 2014 2:30 PM
    Answerer
  • You need to add a measure in the pivot to make the relationship effective.

    Something simple like this should work:

    RowCount:= COUNTROWS(FactOrderDetail)

    That works, thanks!

    How come a measure such as TotalValue:=SUMX(product,product[Cost]) doesnt work?
    Friday, August 8, 2014 3:16 PM
  • CALCULATE was needed! Im an idiot! Thanks for the help guys!
    Friday, August 8, 2014 3:20 PM