How to list all serial number with same transaction number

[PBI_newuser]

Hi, I want to see all the same transcation number to appear on the table when one of the serial number is selected.

For example, when I select "B123", I can see the list of all serial number with the same transaction number. How to do so?

Expected Output when select "B123" on slicer.

Transaction Number	Serial Number
44001111	A123
44001111	B123
44001111	C123

Raw Data:

Transaction Number	Serial Number
44001111	A123
44001111	B123
44001111	C123
44002222	A987
44002222	B987
44002222	C987

[Anonymous]

Hi @PBI_newuser,

Did these suggestions help with your scenario? if that is the case, you can consider Kudo or accept the helpful suggestions to help others who faced similar requirements to find it more quickly.

If these also don't help, please share more detailed information to help us clarify your scenario to test.

How to Get Your Question Answered Quickly 

Regards,

Xiaoxin Sheng

[PBI_newuser]

Hi @Anonymous , would you mind to share a sample file for the suggested solution? Thanks.

[Anonymous]

Hi @PBI_newuser,

Did these suggestions help with your scenario? if that is the case, you can consider Kudo or accept the helpful suggestions to help others who faced similar requirements to find it more quickly.

If these also don't help, please share more detailed information to help us clarify your scenario to test.

How to Get Your Question Answered Quickly 

Regards,

Xiaoxin Sheng

[Anonymous · Accepted solution]

Hi @PBI_newuser,

Sure, please check the below steps:

1. Extract the 'Serial Number' to create a new tale as source of the slicer.

2. Write a measure to extract the selections from the slicer and compare them with the target table records.

Measure =
VAR selected =
    VALUES ( Selector[Serial Number] )
VAR currID =
    SELECTEDVALUE ( Table[Transaction Number] )
VAR idlist =
    CALCULATETABLE (
        VALUES ( Table[Transaction Number] ),
        FILTER ( ALLSELECTED ( Table ), [Serial Number] IN selected )
    )
RETURN
    IF ( currID IN idlist, "Y", "N" )

3. Use this measure on the table visual's 'visual level filter' to choose all "Y" result records.

Notice: Selector is the new table with all 'Serial Number' from table1.

If the above steps are also not suited for your requirement, please share a pbix file here so that we can coding formulas on it to share the sample similar to your data structures.

Regards,

Xiaoxin Sheng

[Ashish_Mathur]

Hi,

See if my solution here helps - Filter a column of a Pivot Table on a certain condition but also show other items from that column.

[amitchandak]

@PBI_newuser , This will work if you slicer of Serial Number comes from an indepdendent table

Try measure like 

Meausre  =

var _tab = summarize(filter(allselected(Table), Table[Serial Number] in values(Table[Serial Number])),  Table[Transaction Number])

return

countx(filter(allselected(Table), Table[Transaction Number] in _tab), Table[Transaction Number])

[PBI_newuser]

Hi @amitchandak , I am not sure how to apply this measure to the table?

[Anonymous]

HI @PBI_newuser,

You can break the relationship between slicer and raw table then you can write measure expression to get the selected value and use it to find out correspond category 'transaction' numbers.

After these steps, you can drag this measure to table visual and use it on 'visual level filter' to filter matched records:

Applying a measure filter in Power BI - SQLBI
Regards,

Xiaoxin Sheng