Total Sales in Matrix table based on some conditions.
I have a sales table with the following tables (exist the attached pbi file) :
There's no relationship between sales table and above tables.
I need to display in Matrix table ( Range int Rows and GM Range in Column) to show Total Sales for those sales that are inside a range ( ex : $7M - $9M) AND in specific GM range (Gross Margin). As a result I should have the following format :