topic Re: Scalable measures and filters within measures in DAX Commands and Tips

Scalable measures and filters within measures

SLJN — Wed, 23 Nov 2022 13:58:27 GMT

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

Re: Scalable measures and filters within measures

amitchandak — Wed, 23 Nov 2022 17:08:14 GMT

SLJN , Try like

Actual weight (NO) =

CALCULATE (

[weight],

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

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

Re: Scalable measures and filters within measures

SLJN — Thu, 24 Nov 2022 09:00:11 GMT

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.

Re: Scalable measures and filters within measures

SLJN — Thu, 24 Nov 2022 09:48:50 GMT

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?