Forum Discussion
Solved
Measure that checks multiple Rows based on one value
Hey Guys,
I can't come up with this Measure, I hope you can help me out!
I have following Table:
| PO-Number | PO Category | Price |
| 12300 | E | 90 |
| 12300 | Q | 90 |
| 22200 | E | 45 |
| 22200 | Q | 45 |
| 33500 | E | 20 |
| 44000 | E | 57 |
So the Measure that I am trying to come up with should check if a PO Number has the Category "E", but not the Category "Q".
If that Case is true, and no row has the category "Q", the Price would be added to the Measure.
Thanks a lot!!
5 Replies
The red ones should also be blank, as these PO Numbers have a row with "E" and a row with "Q".
The last two ones are correct as they only have a row with "E".
wow great, thank you so much!!!
I would have another question that i forgot.
The Price is in another Table with the same PO-Numbers.
Do you know how i could put the price from another table in the variable "selectprice" ?
