topic Re: Dax measure that checks if one row meets criteria, put value for all rows in DAX Commands and Tips

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

CRSB — Tue, 06 Aug 2024 21:29:40 GMT

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

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

Shravan133 — Tue, 06 Aug 2024 23:18:04 GMT

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")

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

ThxAlot — Wed, 07 Aug 2024 02:07:07 GMT

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

CRSB — Wed, 07 Aug 2024 13:41:00 GMT

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?

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

SachinNandanwar — Wed, 07 Aug 2024 17:33:15 GMT

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

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

CRSB — Wed, 07 Aug 2024 19:28:30 GMT

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

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

Anonymous — Thu, 08 Aug 2024 06:29:06 GMT

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.

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

SachinNandanwar — Thu, 08 Aug 2024 06:37:08 GMT

"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.