Unable to Aggregate Calculated Measure in Visual Table

[mbuhary]

Hello Everyone,

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.

https://www.dropbox.com/s/kcaikc1fep2b7lt/Commissions.pbix?dl=0

[v-piga-msft · Accepted solution]

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.

Best  Regards,

Cherry