Group by in PowerBi

Question

Hi,

I have data as below

OrderID	Product	SubProduct	SubProductValue	ProductValue	Above 100
1	A	A	50	100	Yes
1	A	B	25	100
1	A	C	25	100
2	B	A	10	20	No
2	B	B	10	20

*Product Value has value added from sub product value column and put across in all rows.

How can I flag Yes or No based on addition of sub product value where value is >= 100

Answer 1

Hi,

One way is to create a column to group them, then follow the below procedure.

Above 100 Column = IF( SUM([ProductValue]) >= 100,"Yes","No")

The created field groups the rows into Yes or No depending on the condition.