create a measure that shows values if coulmn contains a specific value

[dw700d]

Good day,

I am trying to create a measure that  shows me any equipment id that contains an installed identifier in the installation column.

Current Table

Equipment id	Client	installation	Amount
1	john		100
1	bob	installed	200
2	mike		300
2	marlon		400
3	sara	installed	500
3	ann		600

Desired Table

Equipment id	Client Name	installation	Amount
1	john		100
1	bob	installed	200
3	sara	installed	500
3	ann		600

[daniel79 · Accepted solution]

Maybe you can just do with a visualization level filter?

You could add a measure like this that will return whether the Equipment Id was installed or not.

Installed? = CALCULATE(maxx(Data,Data[installation]),ALLEXCEPT(Data,Data[Equipment id]))

And then filter the table by that measure