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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Regular Visitor

## Scalable measures and filters within measures

Hi

I need help with creating scalable measures. The desired end result is to display a business unit with its  total weight of selected products, and the selected products separately. In example, I want to display the total weight of the products in business unit 1 in total and then when you select business unit 1 i want to show product 1 and 2 seperately.

I have 9 business units that all have several different products. However, its only the selected products that I'm interested in.

The star schema looks as following.

I have done a measure to summarize the total weight called weight (T). And then a measure for each BU like this

Actual weight (NO) =

CALCULATE (

[weight],

BUSINESSUNIT [BUID] = "NO",

PRODUCT[PRODUCT] in ("CORV","RENA")
)

It returns the right sum. But how do I show the result for NO that shows the total weight of CORV and RENA separately?  If I put the measure in a table and then add product it displays all products, not the selected ones.  Also how do I make this scalable? without having to go into each measure ans change the product.

In a table preferable

BU  PRODUCTS WEIGHT

NO                    131

CORV          72

RENA          59

1 ACCEPTED SOLUTION
Super User

@SLJN , Try like

Actual weight (NO) =

CALCULATE (

[weight],

filter( BUSINESSUNIT, BUSINESSUNIT [BUID] = "NO"),

filter(PRODUCT, PRODUCT[PRODUCT] in ("CORV","RENA"))

3 REPLIES 3
Regular Visitor

It works! Thank you!

Do you know how to call on specific values in a Column?

Such as a the products for NO.

I want to build something more scalable. So when the products are changing I only change it in one place.

Super User

@SLJN , Try like

Actual weight (NO) =

CALCULATE (

[weight],

filter( BUSINESSUNIT, BUSINESSUNIT [BUID] = "NO"),

filter(PRODUCT, PRODUCT[PRODUCT] in ("CORV","RENA"))

Regular Visitor

I want to call the certain products for the business units in different measures.

for differentiera time measures etc. Should I do the products as parameters that I call on? Or just variables? And how?

## Helpful resources

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - June 2024

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

#### Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

#### New forum boards available in Real-Time Intelligence.

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

Top Solution Authors
Top Kudoed Authors