cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Helper II

## Flagging entire category if one item is flagged

Hi,

I have two tables, one dim table indicating if an item is shortage item or not, and a fact table containing all orders (items).

The slight twist is that some items must be delivered together thus if even one item within a delivery group is shortage item, I want to see all the other item in that delivery group flagged.

So I have an item column with the list of items, I have a shortage flag per item in a related dim table and a delivery group category column. If a single row is flagged, all the rows with the same delivery group number should be flagged (0 or 1 for example).

I appreciate the help!

1 ACCEPTED SOLUTION
Community Support

Hi @mafaber

If i understand you correctly, you could create a calculated column

``new flag = var sums=CALCULATE(SUM(dim[flag]),FILTER(dim,dim[group]=EARLIER(dim[group]))) return IF(sums>=1,1,0)``

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

2 REPLIES 2
Community Support

Hi @mafaber

If i understand you correctly, you could create a calculated column

``new flag = var sums=CALCULATE(SUM(dim[flag]),FILTER(dim,dim[group]=EARLIER(dim[group]))) return IF(sums>=1,1,0)``

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

#### Fabric Community Update - August 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors