Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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  Co...
Anonymous's avatar
Anonymous
Not applicable
6 years ago

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's avatar
Greg_Deckler
Community Champion
6 years ago

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's avatar
    Anonymous
    Not applicable
    6 years ago

    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

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi Greg, 

    I think that would help me 

    thanks