Table Relationship Issues

Question

 

What am I doing wrong? I have the relationships pictured however when I put in my row labels the data is repeated over and over instead of slicing (look at the pivot counts all are the same).  

Row Labels	Count of possible_cause_description
bananas	88
oranges	88
lemons	88
blueberries	88
Grand Total	88

 Please help.

---

AB

Answer 1

Hello,

I guess the measure "Count of possible_cause_description" if of the dimension table "dpossible_cause_id"? Then you always count the numbers of existing dimension data, not the (sliced) fact data; take the measure from the fact table instead.

---

Olaf Helper

[ Blog] [ Xing] [ MVP]

Answer 2

Wow, thank you Olaf! Rookie mistake.

---

AB