Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to 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
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
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |