cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
mbuhary Frequent Visitor
Frequent Visitor

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 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

1 REPLY 1
Community Support Team
Community Support Team

Re: Unable to Aggregate Calculated Measure in Visual Table

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.

 

Capture.PNG

 

Best  Regards,

Cherry

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.