Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
PBIX file : https://1drv.ms/u/s!Ag9tIyk2ofNRjlBFygNBL3s9VG2N?e=qoIeBc
Excel file: https://1drv.ms/x/s!Ag9tIyk2ofNRjk9-uND6F2ZLZgaZ?e=oAWQzt
I have multiple measures :
ServicerevenueA = CALCULATE(SUM(revenue_table[total]),revenu_table[service]= "Service A")
Total revenue = SUM(revenue_table[total])
PercentageA = [servicerevenueA]/[total revenue]
Service expense = CALCULATE(SUM(expense_table[total]),expense_table[eligible for service revenue] = "true")
ExpenseA = [PercentageA] * [serviceexpense]
you can see the following numbers here :
on october 4 :
on October 5 :
as you see no issues with my calculations
but when i select both dates:
you can see that it shows sum of expense A is 176.81
but if you sum them manually,
october 4 expenseA = 163.58
October 5 expenseA = 32.63
sum should be 196.21 and not 176.81
what should i do?
Solved! Go to Solution.
@Anonymous , You need some common row level field for this
ExpenseA = [PercentageA] * [serviceexpense]
Like sumx(Values(DIm[Customer]), calculate([PercentageA] * [serviceexpense]))
@Anonymous , You need some common row level field for this
ExpenseA = [PercentageA] * [serviceexpense]
Like sumx(Values(DIm[Customer]), calculate([PercentageA] * [serviceexpense]))