Forum Discussion
Measure
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
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.
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