Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

Wrong value when selecting multiple date

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 :

 

service1.png

 

on October 5 :

service2.png

 

as you see no issues with my calculations

 

but when i select both dates:

allservice.png

 

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?

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@Anonymous , You need some common row level field for this

ExpenseA = [PercentageA] * [serviceexpense]

 

Like sumx(Values(DIm[Customer]), calculate([PercentageA] * [serviceexpense]))

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

View solution in original post

1 REPLY 1
amitchandak
Super User
Super User

@Anonymous , You need some common row level field for this

ExpenseA = [PercentageA] * [serviceexpense]

 

Like sumx(Values(DIm[Customer]), calculate([PercentageA] * [serviceexpense]))

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.