topic Re: Measure in DAX Commands and Tips

Measure

Anonymous — Wed, 19 Feb 2020 03:22:46 GMT

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

Re: Measure

Greg_Deckler — Wed, 19 Feb 2020 05:04:16 GMT

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

Re: Measure

Anonymous — Wed, 19 Feb 2020 05:14:52 GMT

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

Re: Measure

Greg_Deckler — Wed, 19 Feb 2020 05:35:24 GMT

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.

Re: Measure

Anonymous — Wed, 19 Feb 2020 07:34:14 GMT

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

Re: Measure

Anonymous — Wed, 19 Feb 2020 22:38:37 GMT

Hi Greg,

I think that would help me

thanks