Beginner - simple dax (weight and groups)

[DennisSchlein]

Hi

I have created a table with 3 values.
Order id
BilledWeightCost

BilledWeightSales

Weight is a decimal number.

What I want to do it adding a weightbreak:
WB                MinWeight   MaxWeight

1	0	1
2	1	2
3	2	3
5	3	5
10	5	10
15	10	15
20	15	20
25	20	25
30	25	30
35	30	35
40	35	40
45	40	45
50	45	50

I wand to add both weight fields to a WB - and then compare where WB on cost is higher than on sales?

[DennisSchlein]

Hi @Greg_Deckler 

Thanks for the advice, ill have that in mind when posting.

I wil try to explain a little better 😛


As example I have a small table:

Order_id	BilledWeightCost	BilledWeightSales
1	1,0	1
2	1,7	2,4
3	3,8	10

For both weight columns I want to put them into a weight break that is weight grouped like this:

WB	MinWeight	MaxWeight
1	0	1
2	1	2
3	2	3
5	3	5
10	5	10
15	10	15

So both billedweightcost and sales should be put into a WB from 2. table where weight is between min and max weight.

And then I want to filter those order where WB from cost is higher than WB from sales.

Order_id	WB_Sales	WB_Cost
1	1	1
2	2	3
3	5	10

Does that make sense?

[Greg_Deckler]

@DennisSchlein Sorry, what is the expected output you desire? Not quite understanding so maybe an example would help. Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.