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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Pikachu-Power
Post Prodigy
Post Prodigy

Wrong Total / Measure Problem

Hello,

 

I probably have a simple problem where i am looking for a simple way 🙂

 

Measure:

Consumption = CALCULATE(SUM(Table[Value]))
 
When I multiply later the Consumption with Numbers I get following wrong result for the Total:
Unbenannt.PNG
 
Measure Multiplication = Clients * Consumption 
 
How do I have to change the DAX formula in the Measure Multiplication to get the right value?
 
Thanks!
 
1 ACCEPTED SOLUTION
tamerj1
Super User
Super User

Hi @Pikachu-Power 

please use

Measure Multiplication =

SUMX (

VALUES ( TableName[Segmaent] ),

[Clients] * [Consumption]
)

View solution in original post

3 REPLIES 3
Fowmy
Super User
Super User

@Pikachu-Power 

Modify the measure as follows:

Total = 
SUMX( VALUES ( Table[Segment] ) , [Clients] * [Consumption] )
Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

Great that's it!

tamerj1
Super User
Super User

Hi @Pikachu-Power 

please use

Measure Multiplication =

SUMX (

VALUES ( TableName[Segmaent] ),

[Clients] * [Consumption]
)

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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