Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hey,
I have a problem that i assume is extremely easy to fix but i can't get my head around it.
I have a Year column, 2021, 2022 or 2023, which i a want to filter on.
I also have another text column, with two values "Filter" and "Don't Filter".
(The "Don't Filter" rows do have a Year value assocaited with them at the moment but this can be blanked or Nulled if needed)
I want to be able to filter my table based on the Year column, but i never want to filter out the "Don't Filter" rows.
How do i go about this?
@Wynner , A measure
calculate(Sum(Table) , Filter(Table, Table[Column] <> "Don't Filter" ))
Hi,
Not sure what the code above should do. Also, i tried it and it says i can't use SUM() over a full table, only a column.
User | Count |
---|---|
54 | |
47 | |
19 | |
16 | |
15 |
User | Count |
---|---|
114 | |
44 | |
44 | |
28 | |
22 |