locked
Table Relationship Issues RRS feed

  • 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

    Tuesday, November 24, 2015 3:15 PM

Answers

  • 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]

    • Marked as answer by IcyBricks Tuesday, November 24, 2015 3:38 PM
    Tuesday, November 24, 2015 3:26 PM

All replies

  • 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]

    • Marked as answer by IcyBricks Tuesday, November 24, 2015 3:38 PM
    Tuesday, November 24, 2015 3:26 PM
  • Wow, thank you Olaf! Rookie mistake.

    AB

    Tuesday, November 24, 2015 3:38 PM