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

Reply
SLJN
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. 

 

SLJN_0-1669210881492.png

 

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
amitchandak
Super User
Super User

@SLJN , Try like

 

Actual weight (NO) = 

CALCULATE ( 

[weight], 

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

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

View solution in original post

3 REPLIES 3
SLJN
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. 

 

amitchandak
Super User
Super User

@SLJN , Try like

 

Actual weight (NO) = 

CALCULATE ( 

[weight], 

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

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

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
Sept PBI Carousel

Power BI Monthly Update - September 2024

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

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

Find out what's new and trending in the Fabric Community.