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
dukealb
Regular Visitor

Sum Values month-over-month var

Hi

I'm still a simple user of powebi,

I created a measure to calculate the Month-over-month cost variation (MoMDiff) and in the results I have negative and positives numbers.

The table below is filtered MoMdiff > 0.

 

WhatsApp Image 2022-08-03 at 10.05.39 PM.jpeg

 

I would like to sum and isoleted the positive numbers and negative numbers to have a card that displays both sum for better analysis.

 

Please it would be great if some one could help me.

 

Thank you in advance

1 ACCEPTED SOLUTION
ryan_mayu
Super User
Super User

@dukealb 

maybe you can try this

Measure = sumx(FILTER(VALUES('Table'[resourceid]),[MoMDiff]>0),[MoMDiff] )

Measure 2 = SUMX(FILTER(VALUES('Table'[resourceid]),[MoMDiff]<0),[MoMDiff] )

1.png





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

3 REPLIES 3
ryan_mayu
Super User
Super User

@dukealb 

maybe you can try this

Measure = sumx(FILTER(VALUES('Table'[resourceid]),[MoMDiff]>0),[MoMDiff] )

Measure 2 = SUMX(FILTER(VALUES('Table'[resourceid]),[MoMDiff]<0),[MoMDiff] )

1.png





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Hi Ryan,

 

Thank you so much for your awnser, it worked fine.

Regards

you are welcome





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




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.