Forum Discussion

mbuhary's avatar
mbuhary
Helper I
7 years ago
Solved

Unable to Aggregate Calculated Measure in Visual Table

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 ha...
Need Help
  • v-piga-msft's avatar
    v-piga-msft
    7 years ago

    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

v-piga-msft's avatar
v-piga-msft
Resident Rockstar
7 years ago

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