Forum Discussion
Match selected number in same table column
- 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
PoojaDarbhe Thanks, i did the same and it's working for me.
Good to hear that VD.
As this solution is working for you, it will be great if you accept the solution. Thanks a lot.
Best regards,
Pooja Darbhe