Forum Discussion

VD's avatar
VD
Frequent Visitor
5 years ago
Solved

Match selected number in same table column

I am having table named as TABLE_1, I want output like, when user select Batch_Number "AT0164" then, it should check that Batch number in Parent_Order_Number column and should return a rows that mat...
Need Help
Tips and Tricks
  • amitchandak's avatar
    amitchandak
    5 years ago

    VD , best is you have an independent batch table and create a measure like this and add this with all un summarized columns  in a table visual

     

    measure =
    var _max = maxx(allselected(Batch_Number),Batch_Number[Batch_Number])
    return
    calculate(count(Table[Batch_Number]), filter(Table, table[parent_order_number] = _max))

     

     

    or with same table batch_number as slicer 

     

    measure =
    var _max = maxx(Table(Batch_Number),Table[Batch_Number])
    return
    calculate(count(Table[Batch_Number]), filter(Table, table[parent_order_number] = _max), removefilters(Table[Batch_Number]) )

     

    refer Need of an Independent Table in Power BI: https://youtu.be/lOEW-YUrAbE

amitchandak's avatar
amitchandak
Super User
5 years ago

VD , best is you have an independent batch table and create a measure like this and add this with all un summarized columns  in a table visual

 

measure =
var _max = maxx(allselected(Batch_Number),Batch_Number[Batch_Number])
return
calculate(count(Table[Batch_Number]), filter(Table, table[parent_order_number] = _max))

 

 

or with same table batch_number as slicer 

 

measure =
var _max = maxx(Table(Batch_Number),Table[Batch_Number])
return
calculate(count(Table[Batch_Number]), filter(Table, table[parent_order_number] = _max), removefilters(Table[Batch_Number]) )

 

refer Need of an Independent Table in Power BI: https://youtu.be/lOEW-YUrAbE

  • VD's avatar
    VD
    Frequent Visitor
    5 years ago

    amitchandak, Thanks for the solution. 

    I have created new table with single column Batch and join that table with actual table and it's working perfectly fine.