The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
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]))
User | Count |
---|---|
15 | |
12 | |
8 | |
7 | |
7 |
User | Count |
---|---|
24 | |
21 | |
12 | |
10 | |
7 |