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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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

MayPowerBICarousel

Power BI Monthly Update - May 2024

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