Forum Discussion
Solved
Measure for selected values
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
I think I sorted it out by the following measure:
Measure = CALCULATE(SALES; PRODUCT_TABLE; PRODUCT_NO IN {"12345"; "23456"; "34567"}))
1 Reply
I think I sorted it out by the following measure:
Measure = CALCULATE(SALES; PRODUCT_TABLE; PRODUCT_NO IN {"12345"; "23456"; "34567"}))