Forum Discussion

faldiwan's avatar
faldiwan
Frequent Visitor
2 years ago

ALLSELECTED OR NOT?

Hi all,   I need some help please, I have a simple tabular model. 3 tables Portfolio, Position & Date. The Portfolio table is pretty much a type 1 dimension, Position is a fact table.  The v...
faldiwan_ar's avatar
faldiwan_ar
Frequent Visitor
2 years ago

Hi,

Im expecting to see 4000, not 6. 

 

So ive selected Apple like you did and in the company filters selected Company Test1 & Test2, so i should expect to see the sum of the values for both Test1 & Test2.

 

Your result is returning all 3 companies, when i only selected 2 in my filter

  • lbendlin's avatar
    lbendlin
    Super User
    2 years ago

    That's a "wash me but don't make me wet"  scenario.  You need to use disconnected tables and measures.

    • faldiwan_ar's avatar
      faldiwan_ar
      Frequent Visitor
      2 years ago

      Hi,

       

      I was hoping I wouldnt need to remodel, but i assumed that would be the case.

       

      Thanks for helping