Forum Discussion

zbeg's avatar
zbeg
Frequent Visitor
5 years ago
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....
  • wdx223_Daniel's avatar
    wdx223_Daniel
    5 years ago

    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

     

wdx223_Daniel's avatar
wdx223_Daniel
Icon for Community Champion rankCommunity Champion
5 years ago

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

 

zbeg's avatar
zbeg
Frequent Visitor
5 years ago

wdx223_Daniel thank you so much! That worked, and now I'm able to break it apart and see what I was doing wrong. I appreciate this a lot. Thank you for taking the time to respond.