Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello, I have the following code and am looking to add a filter to it to remove inputs in another column. I've filtered for, but never against and never from a different column, so I'm a little out of my element. Any help would be greatly appreciated.
Solved! Go to Solution.
Hi @Anonymous ,
As the official document said, ALL() function returns all the rows in a table, or all the values in a column, ignoring any filters that might have been applied. This function is useful for clearing filters and creating calculations on all the rows in a table.
Please try the following formula to add a column:
Active =
VAR __CurrentRowID = Main[Employee ID]
RETURN
CALCULATE (
COUNTROWS ( 'Main' ),
FILTER (
'Main',
'Main'[mgr_emplid] = __CurrentRowID
&& NOT ( [Position]
IN { "Team Member", "Team Member - Nights", "Team Member - Nights - DO" } )
)
)
The final output is shown below:
Here is the pbix file.
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous ,
As the official document said, ALL() function returns all the rows in a table, or all the values in a column, ignoring any filters that might have been applied. This function is useful for clearing filters and creating calculations on all the rows in a table.
Please try the following formula to add a column:
Active =
VAR __CurrentRowID = Main[Employee ID]
RETURN
CALCULATE (
COUNTROWS ( 'Main' ),
FILTER (
'Main',
'Main'[mgr_emplid] = __CurrentRowID
&& NOT ( [Position]
IN { "Team Member", "Team Member - Nights", "Team Member - Nights - DO" } )
)
)
The final output is shown below:
Here is the pbix file.
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Anonymous , not very clear you can use all or removefilters
refer: https://www.linkedin.com/pulse/five-recent-power-bi-functions-you-should-use-more-often-amit-chandak
I read your article, and maybe I'm misunderstanding or I wasn't clear. I'm trying to add a filter to the command to filter out certain values.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
75 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |