Measure that finds a column value but does not filter on that column in visualizations

[d_lkab]

Hi!

I want to write a measure that finds the maximum value in a set of rows and returns that value on all the rows in a visualization. This is what i want:

Column_1  Column_2  Value_Column  Result_of_Measure_max

1                A                10                     20

1                A                20                     20

1                B                10                     10

2                C                100                   300

2                C                300                   300

2                D                1000                 1000

My problem is to write the measure so that it does not filter by the Value_Column in the visualization. This is what I get:

Column_1  Column_2  Value_Column  Result_of_Measure_max

1                A                10                     10

1                A                20                     20

1                B                10                     10

2                C                100                   100

2                C                300                   300

2                D                1000                 1000

You see the difference? How to exclude filters from a column in the visualization but still use it to evaluate the meassure?

Does anyone know the trick? And maybe the theory behind it?

Thanks for all the help with previous questions!

Cheers 

/D

[Jihwan_Kim · Accepted solution]

Hi, @d_lkab 

Please check the below.

Result Measure =
CALCULATE (
MAX ( 'Table'[Value_Column] ),
ALLEXCEPT ( 'Table', 'Table'[Column_2] )
)

https://www.dropbox.com/s/mi48t8t2ubqwrg4/ikab.pbix?dl=0 

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Linkedin: linkedin.com/in/jihwankim1975/

Twitter: twitter.com/Jihwan_JHKIM

[v-yangliu-msft · Accepted solution]

Hi  @d_lkab ,

Here are the steps you can follow：

1. Create measure.

Measure = CALCULATE(MAX('Table'[Value_Column]),FILTER(ALL('Table'),'Table'[Column_2]=MAX('Table'[Column_2])))

2. Result.

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Jihwan_Kim · Accepted solution]

Hi, @d_lkab 

Please check the below.

Result Measure =
CALCULATE (
MAX ( 'Table'[Value_Column] ),
ALLEXCEPT ( 'Table', 'Table'[Column_2] )
)

https://www.dropbox.com/s/mi48t8t2ubqwrg4/ikab.pbix?dl=0 

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Linkedin: linkedin.com/in/jihwankim1975/

Twitter: twitter.com/Jihwan_JHKIM

[d_lkab]

Hi!

Thank you for your reply!

This could be a solution. This is a somewhat simplified table though. In reality there are about 5 column that should be an Allexcept(column1, 2, 3, 4, 5) and about 5 columns that should not work as a filter. I guess I coul write all except for att the columns though. I have to look inte that!

Cheers!

/Desiré