I know this issue was discussed in previous posts, but the solutions suggested doesn't work with my situation.
Please see in the attached PBIX Model (DropBOX link below). I have Calculated Measures. The problem is I am unable to arrive at the proper aggregate for Measure - "Sales_Commission" it should give 94,000.
Hi @mbuhary ,
By my tests and research, you could modify your measure like below.
Measure = VAR Sales_CommissionX = [Sales] * [Commission_Slab] VAR CommissionTable = SUMMARIZE ( f_Data, 'f_Data'[Month], "TotalCommission", Sales_CommissionX ) RETURN IF ( AND ( HASONEFILTER ( f_Data[Product code] ), HASONEFILTER ( f_Data[Month] ) ), Sales_CommissionX, SUMX ( CommissionTable, CALCULATE ( [Sales] * [Commission_Slab] ) ) )
Here is your desired output.