understanding the max and filters - HELP

Anonymous · ‎07-01-2020

Hi folks,

I have the current table, which is filtered by the slicer at the left, so as you can see, last element is the wellid column is the highest number and that correspond to the vendor "XTO", i can get the name by simply MAX(table[operator]), but when just trying to set a logical measure it is when i struggle to find logic, if i can just simply write IF(MAX(TABLE[Operator]) = "XTO", 1, 0) works great, however my goal is to get only those 3 XTO elements as they are the latest operator value, however if somebody can explain the logic behind the if when referencing the same value at the same column,

this would be the desire output,

however i would like to understand the logic the the "XTO" is a dynamic variable, if i do this:

_amount = 
IF('Well List'[_check] = MAX('Well List'[Operator]), 1, 0) ALL THE ROWS = 1

Is the logic filtering and evaluating each row independently and so for each row thats the max value?

the challenge here is there are not another unique value other than the string name to reference.

FrankAT · ‎07-01-2020

Hi @Anonymous,

[1]

Each measure equals to the same result.

MAX(), MIN() or SELECTEDVALUE() of only one value is the value itself, ex.: MAX("XTO") = "XTO"

The measure says: If the value in Column1 is "XTO" then display 1 otherwise 0. All rows in the matrix gets a value.

[2]

Same as [1], but the measur says: If the value in Column1 is "XTO" then display 1 otherwise BLANK. The default behavior of the matrix doesn't show rows with blank values. You can change this behavior in the field options.

Regards FrankAT

Anonymous · ‎07-01-2020

Hi Frank,

Thanks for your response, what about if XTO is a variable calculated as the Max wellid? it works great when i write ""XTO", however seems when i create a variable to calculate the max of operator based on max of wellid, that seems to return always 1, XTO will change once i select a different product or if there is a new newst client which this caseis the operator.