Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. 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]))
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
23 | |
8 | |
7 | |
6 | |
6 |
User | Count |
---|---|
28 | |
12 | |
10 | |
10 | |
6 |