Forum Discussion

rookie's avatar
rookie
New Member
8 years ago
Solved

COUNT DISTINCT

I have a very simple scheme – products, outlets, sales But when I’m trying to calculate SUM(Sales), COUNT (DISTINCT POP_Physical_id)  by  Product_Brand – I’ve got correct sum for each brand but one ...
Need Help
  • v-chuncz-msft's avatar
    v-chuncz-msft
    8 years ago

    rookie,

     

    You may try to set cross filter direction to 'Both' in the Edit relationship dialog.

v-chuncz-msft's avatar
v-chuncz-msft
Icon for Community Support rankCommunity Support
8 years ago

rookie,

 

You may try to set cross filter direction to 'Both' in the Edit relationship dialog.