Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
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
mnb_dk
Helper I
Helper I

Measure for selected values

‎05-15-2023 03:30 AM

Hi

I would like to make a graph with two values. One showing all sales and one showing only sales for selected products (e.g 50 products).

How can I make this in PowerBI? I assume I need to make a measure or do I need to make a new table?

 

Best,

Mathias

Labels:
Message 1 of 2
223 Views
0
1 ACCEPTED SOLUTION
mnb_dk
Helper I
Helper I

‎05-15-2023 05:19 AM

I think I sorted it out by the following measure:

Measure = CALCULATE(SALES; PRODUCT_TABLE; PRODUCT_NO IN {"12345"; "23456"; "34567"}))

 

View solution in original post

Message 2 of 2
171 Views
1 REPLY 1
mnb_dk
Helper I
Helper I

‎05-15-2023 05:19 AM

I think I sorted it out by the following measure:

Measure = CALCULATE(SALES; PRODUCT_TABLE; PRODUCT_NO IN {"12345"; "23456"; "34567"}))

 

Message 2 of 2
172 Views

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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

MayPowerBICarousel

Fabric Monthly Update - May 2024

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

View All