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 and the same value of  the second column  equal to overall number of COUNT (DISTINCT POP_Physical_id)   in POPs.  How can I resolve this issue without adding new custom lookup column POP_Phys_id = RELATED(POPs[POP_Physical_id]) ?

Need Help

1 Reply

  • v-chuncz-msft's avatar
    v-chuncz-msft
    Community Support
    8 years ago

    rookie,

     

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