Create a DAX measure to return all text values from a table.

[Mark_Berry]

Hello everyone.

I am trynig to create a measure which returns the enitre tex contents of a colum to work in conjunction with a slicer which works across mulitple tables. 
An example of ameasure which works with the slicer is as follows

Count of Not Overdue =

if(

HASONEVALUE('Slicer Table'[Value1]),

SWITCH(

values('Slicer Table'[Value1]),

    "Work Pack",Calculate(COUNTA('Work Pack'[Overdue]),FILTER('Work Pack','Work Pack'[Overdue]="Not Overdue")),

    "Non Compliance",Calculate(COUNTA('INon Compliance'[Overdue]), FILTER('Non Compliance','Non Compliance'[Overdue] ="Not Overdue")),

    "Work Lots",Calculate(COUNTA('Work Lots'[Overdue]),FILTER('Work Lots','Work Lots'[Overdue] = "Not Overdue")),

    "Questions", Calculate(COUNTA('Questions'[Overdue]),FILTER('Questions','Questions'[Overdue] = "Not Overdue")),

    "Requests",Calculate(COUNTA('Requests'[OverDue]),FILTER('Requests','Requests'[OverDue]="Not Overdue")

)))
I need to use a similar dax to return all values which are in collumns named " Reference". and "Description"

Ultimately I would like the below to be the result for each slicer selection. 

Reference	Description
Lot#1	Information
Lot#2	Information
Lot#3	Information

Reference	Description
Questions#1	Information
Questions#2	Information
Questions#3	Information

[Mark_Berry]

Data is currently structured as individual tables in excel eg Work Pack is one table.

The meausre I have supplied above is one which corresponds to a slicer table I have created to allow switching between each report type for values that are numerical in format.
Each report type has a collum which is the reference eg Lot#1 for each individual report, I would like develop a measure that allows my slicer to return the entire collum contents of text collums.  the end result would look like this 

When Lots is selected

Reference	Description
Lot#1	Information
Lot#2	Information
Lot#3	Information

When Question is Selected

Reference	Description
Questions#1	Information
Questions#2	Information
Questions#3	Information

[Daniel29195]

@Mark_Berry 

sorry but i didnt quite understand your requirement, 

it would be helpful if you could share sample data , just to know how the data is structured. 

best regards