Forum Discussion
Advocate IDates Driving me Crazy
Hi Alboy,
Thank you for reaching out to the Microsoft fabric community forum. Thank you danextian, govind_021, for your inputs on this issue.
After thoroughly reviewing the details you provided, I was able to reproduce the scenario, and it worked on my end. I have used it as sample data on my end and successfully implemented it.
Dax Measure for Total returns in returns table:Total Returns = SUM(Returns[ReturnAmount])Dax Measure for Total sales in sales table:
Total Sales = SUM(Sales[Amount])Relationship:
Outcome:
I am also including .pbix file for your better understanding, please have a look into it:
If this post helps, then please give us ‘Kudos’ and consider Accept it as a solution to help the other members find it more quickly.
Thank you for using Microsoft Community Forum.
Community SupportHi Alboy,
Thank you for reaching out to the Microsoft fabric community forum. Thank you danextian, govind_021, for your inputs on this issue.
After thoroughly reviewing the details you provided, I was able to reproduce the scenario, and it worked on my end. I have used it as sample data on my end and successfully implemented it.
Dax Measure for Total returns in returns table:
Total Returns = SUM(Returns[ReturnAmount])Dax Measure for Total sales in sales table:
Total Sales = SUM(Sales[Amount])Relationship:
Outcome:
I am also including .pbix file for your better understanding, please have a look into it:
If this post helps, then please give us ‘Kudos’ and consider Accept it as a solution to help the other members find it more quickly.
Thank you for using Microsoft Community Forum.
Advocate IThanks for that. I have tried however the filtering only works on the Period Plan table - evrything from Order2Install table is omitted:
I can work around by just deleting all relationships and adding filters for each table - just a little bit messy is all but looks like I'll need to move on and just do that 🙂 Thanks all for the assist 🙂
- Alboy
I take it back - I used a new data table (like yours) as opposed to the generic one I use (which combines data with period, Financial Period etc) and it worked perfectly - thank you!