Forum Discussion
Solved
DAX Measure breaks relationship
Hello Power BI community, I have two tables for my pizza business. Customers submit an order in the PizzaOrderForm table. I have a second table, Pizza, which uses a measure to see what's missing....
firstly unpiovt your tables as this
and this
then create a measure like this
Still Needs = IF(SELECTEDVALUE(PizzaOrderForm[Form_OrderID]),CONCATENATEX(FILTER('PizzaOrderForm','PizzaOrderForm'[Form_OrderID] IN VALUES(Pizza[OrderID])&&NOT('PizzaOrderForm'[Attributes] IN VALUES('Pizza'[Attributes]))),'PizzaOrderForm'[Items],","))then create a table visual and put the Form_OrderID, OrderID and the measure in the values area, like this
