Forum Discussion
Memorable MemberMeasure creates Duplicate Rows
Hi Migasuke ,
This is related to the filtering direction, you can set the filtering direction to be both.
If it is a Single direction, for example, A filters B in one direction, A can filter B, but B cannot filter A.
Here is the relevant link, I hope it will help you:
Result：
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Super UserMigasuke , You should also use a dimension for delivery companies. Tables A and B have no join. And Delivery company from A is need as a group by.
I think in first visual it is first of last and in second it is group by .
If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
- Migasuke
Hi amitchandak ,
in first visual it is not first/last. I basically create copy of the table and then just add Revenue = SUM([Revenue]). I have uploaded the file in case you want to check:
https://we.tl/t-XRxEW5W8WH
Thanks a lot for your help and curiosity.
