cancel
Showing results 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],

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(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(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?

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.

New forum boards available in Real-Time Intelligence.

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

Top Solution Authors
Top Kudoed Authors