Dax measure that checks if one row meets criteria, put value for all rows

[CRSB]

Looking for assistance for a measure for the last column in example below, if a hub building has inventory, show yes for all buildings that fall under that hub. 

Building	Building Type	Servicing Hub	Inv	Hub Has Inv.
A	Hub	A	10	Y
B	Trad	A	8	Y
C	Trad	A	5	Y
D	Hub	D	0	N
E	Trad	D	10	N
F	Trad	D	2	N

[ThxAlot]

[CRSB]

this worked, but i forget one of my tables has item # as a column, so how could i modify to check if the hub/item combonation has inventory?

[SachinNandanwar]

Flag = 
IF(CALCULATE(
  MIN(Table[Inv]),
    ALLEXCEPT( Table, Table[Servicing Hub] ),Table[Building Type]="HUB",Table[Item Column]="Your Condition"
)=0,FALSE(),TRUE())

[CRSB]

I can't get this to work, what is the "Your Condition"?

below would be the table 

Building	Building Type	Servicing Hub	Item	Inv	Hub Has Inv.
A	Hub	A	A	10	Y
B	Trad	A	A	8	Y
C	Trad	A	A	5	Y
D	Hub	D	B	0	N
E	Trad	D	B	10	N
F	Trad	D	B	2	N
A	Hub	A	C	0	N
G	Trad	A	C	10	N

[SachinNandanwar]

"Your Condition" was a placeholder.

Because you hadnt mentioned the condition that you would like to check.So just replace "Your Condition" the value that you would want to check.

[Anonymous · Accepted solution]

Hi @CRSB ,

For your proposed new table, I have also created a table.

I think you can create the following DAX code for your needs.

Column = 
IF (
    'Table'[Servicing Hub] = "A"
        && 'Table'[Item] = "A"
        && 'Table'[Inv] > 0,
    "Y",
    "N"
)

Best Regards

Yilong Zhou

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

[Shravan133]

try this: 

Hub Has Inv =
VAR HubWithInv =
CALCULATE(
MAX('Table'[Inv]),
FILTER(
ALL('Table'),
'Table'[Servicing Hub] = MAX('Table'[Servicing Hub])
)
)
RETURN IF(HubWithInv > 0, "Y", "N")