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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
jbqrn
Helper I
Helper I

Obtain the positive values in a table

Hi!


I want to create a table where I only obtain the positive values per Supplier. 
I mean, I sum the column [Amount] and then I add the new measure to a table, summarizing by Supplier (or whatever), then I olny what the positive balance of the summary, not just the positive values of the column [Amount], ask for more info if its not clear enough.

EXAMPLE:

Transactions:

Supplier

Amount

CODE

1000A

500

wrqw1324

2000B3009861jes
3000C250130i-23

1000A

-10000197321-222
2000B

-1500

31212-22

1000A

-400

312-22

3000C

3004567g-4

2000B

200gggl94-33

 

Summary table:

 

Supplier

Amount

1000A

-900
2000B-1200
3000C550

 

Desired table: 

I only want the negative values of the Summary table, (in other cases the positive values)

Supplier

Amount

1000A

-900
2000B-1200



 

How can I obtain it???

 

Thank you so muc

 

1 ACCEPTED SOLUTION
lbendlin
Super User
Super User

As soon as you add a field to a visual you can filter by that field, and if that field is aggregated then the filter works on the aggregation,  Specify "Amount < 0" and only suppliers with negative balance will show. 

View solution in original post

2 REPLIES 2
jbqrn
Helper I
Helper I

Thank you! 
I thought it works in the context of line in original data... 😥   thank you so much hehehe

lbendlin
Super User
Super User

As soon as you add a field to a visual you can filter by that field, and if that field is aggregated then the filter works on the aggregation,  Specify "Amount < 0" and only suppliers with negative balance will show. 

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.