Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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
Solved! Go to Solution.
@SLJN , Try like
Actual weight (NO) =
CALCULATE (
[weight],
filter( BUSINESSUNIT, BUSINESSUNIT [BUID] = "NO"),
filter(PRODUCT, PRODUCT[PRODUCT] in ("CORV","RENA"))
)
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.
@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?
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
25 | |
18 | |
18 | |
18 | |
17 |
User | Count |
---|---|
34 | |
25 | |
18 | |
16 | |
13 |