Forum Discussion
Apply data to all rows in a filtered column
- 5 months ago
You have a few different options.
You can join the output to a reference of your original table. Steps would be: 1) finalize your original table, disable load; 2) reference your original from #1 and perform the grouping I outlined above, disable load; 3) reference your original from #1, join the categories from #2, enable load
While this is relatively straightforward to do through the UI, it's not as performant as just doing the work inside the group. For that you'll have to implement with M in your formula bar or advanced editor. Here is the full advanced editor snip:
let Source = Sample, GroupOps = Table.Group(Source, {"Owner"}, {{ "GroupOps", each [ grouped_rows = _, group_category = if List.Max(grouped_rows[Tiers]) >= 3 then "Yes" else "No", grouped_rows_with_category = Table.AddColumn( grouped_rows, "Threshold Met", each group_category, type text ) ][grouped_rows_with_category], type table }}), Combine = Table.Combine( GroupOps[GroupOps] ) in CombineOutput:
So when you say 'to understand how all rows in a filtered column can be changed if one defined condition is met', you mean if one row for an owner meets a condition (Tier ≥ 3), then every row for that owner should change to the same result (YES) and condition applies to the entire group?
You can use a DAX for a new Column
ALLEXCEPT() evaluates across all rows for that owner.
- aw3w26 months agoRegular Visitor
This is GREAT and it works- THANK YOU!!! One more question... how do I get a count of the owners meeting Yes and No status? Ultimately I just want 1 status per owner...
- MasonMA6 months agoSuper User
You would need to create DAX measures (not column in table view) for owners who met the threshold like,
Owners (YES) =
CALCULATE(
DISTINCTCOUNT('Table'[Owner]),
'Table'[Tier] >= 3
)Owners (NO) =
DISTINCTCOUNT('Table'[Owner]) - [Owners (YES)]