Group by in PowerBi

+1 vote

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

Aug 11 in Power BI by anonymous
• 210 points
39 views

1 answer to this question.

+1 vote
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.
answered Aug 11 by anonymous
• 28,280 points