Forum Discussion
Measure
Hi folks,
I am just new in Power Bi and less experience.
I need to create a column that won't be affected by filtering. can i do that?
for example,
column A contains 1 to 10 as number
Columns B = 4 and 6 of Columns B * 100
how can I make sure the column B will be Ok if Used filter 4 and 6 in column A.
thanks Guys
OK, I read this one through multiple times and I am still not clear on what you are asking here.
You have a Table and it has a column called A that contains numbers that range from 1 to 10 (1, 2, 3, 4, 5, 6, 7, 8, 9, 10). This table also has a Column B. This is where I lost it.
Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
5 Replies
OK, I read this one through multiple times and I am still not clear on what you are asking here.
You have a Table and it has a column called A that contains numbers that range from 1 to 10 (1, 2, 3, 4, 5, 6, 7, 8, 9, 10). This table also has a Column B. This is where I lost it.
Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Hi Greg,
thanks for your reply,
I continue your reply to get more clear
You have a Table and it has a column called A that contains numbers that range from 1 to 10 (1, 2, 3, 4, 5, 6, 7, 8, 9, 10). This table also has a Column called B that contains 4, 6 only.
(4 and 6 have same value of columns A (4,6) )
now, once I use filter 4 and 6 from column A,
the 4 adn 6 from column B will be filtered.
how can I make sure the filteration wouldn't affect column B?
I want to know that I can use independent filtering ?
thansk again
Not sure I am 100% clear but it sounds like what you want to do is use ALL or ALLEXCEPT or possibly REMOVEFILTERS to essentially remove the filtering of the A column when performing calculations that involve the B column.