Measure

[Anonymous]

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 

[Greg_Deckler · Accepted solution]

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

[Anonymous]

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 

[Greg_Deckler]

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.

[Anonymous]

Hi Greg, 

I think that would help me 

thanks 

[Anonymous]

Hi @Anonymous 

Still your data is insufficient. 

Please share your dataset in tabular format and expected output.

It will be easier for us to answer your question.

Thanks,

Pravin