Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

How to stop visual table from displaying duplicate values when filtered (contains a measure)

Hello there, I have an issue with an invoice table that shows every single invoice instead of the ones that are supposed to be filtered. This problem only occurs when I add the +SO column in the tabl...
Need Help
Applicable88's avatar
Applicable88
Impactful Individual
4 years ago

Hi Anonymous , as I understood correctly, the two columns are from different table and you try to filter from the many side? Please first turn on bidirectional filtering in Data model and see if it solves your issue with "every row same amount". 

If that is cleared I would recommend to use Related()-function to expand the one side of the 1:n relationship into your facttable. I cannot see how you calculated your other measures before you put it into the one you posted. 

Best.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Applicable88 thanks for the response. 

    The Deals to Invoices isn't bi-directional so that shouldn't be an issue should it? Anyway I did turn off some of hte other bi-directional relationships and the problem was still there. I did make the Deals and Invoices bi-directional and it solved the problem. But I don't like bi-directional relationships because of ambiguity in the model, so I try my best to avoid them. 

    The other measures I believe you're referring to are the ones referenced in the + SO one? They're all in Deals also and they're simply just a sum of, counting the totals, that's it.