Need to split distinct value from a single row need dynamic solution based on commo separated value

[ashishg]

I have one column within table that have value like "Input"
as we have same value like xyz and pqr but on output section only single value will be appear
I need a output like shown below but using DAX only, I don't want to use Power query

[lbendlin · Accepted solution]