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

Question

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.&nbsp;An example of ameasure which works with the slicer is as followsCount of Not Overdue =if(HASONEVALUE('Slicer Table'[Value1]),SWITCH(values('Slicer Table'[Value1]),&nbsp; &nbsp; "Work Pack",Calculate(COUNTA('Work Pack'[Overdue]),FILTER('Work Pack','Work Pack'[Overdue]="Not Overdue")),&nbsp; &nbsp; "Non Compliance",Calculate(COUNTA('INon Compliance'[Overdue]), FILTER('Non Compliance','Non Compliance'[Overdue] ="Not Overdue")),&nbsp; &nbsp; "Work Lots",Calculate(COUNTA('Work Lots'[Overdue]),FILTER('Work Lots','Work Lots'[Overdue] = "Not Overdue")),&nbsp; &nbsp; "Questions", Calculate(COUNTA('Questions'[Overdue]),FILTER('Questions','Questions'[Overdue] = "Not Overdue")),&nbsp; &nbsp; "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.&nbsp;ReferenceDescriptionLot#1Information&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Lot#2Information&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Lot#3Information&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ReferenceDescriptionQuestions#1Information&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Questions#2Information&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Questions#3Information&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

daniel29195 · Answer

Mark_Berry&nbsp;&nbsp;sorry but i didnt quite understand your requirement,&nbsp;it would be helpful if you could share sample data , just to know how the data is structured.&nbsp;&nbsp;&nbsp;best regards

mark_berry · Answer

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.&nbsp; the end result would look like this&nbsp;When Lots is selectedReferenceDescriptionLot#1Information&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Lot#2Information&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Lot#3Information&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;When Question is SelectedReferenceDescriptionQuestions#1Information&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Questions#2Information&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Questions#3Information&nbsp;&nbsp;&nbsp;

Forum Discussion

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

2 Replies

Related content

Create Measure to Return Highest Value

Measure returning incorrect value

Need help creating a measure

Help to create DAX Measure

Create measure to return value from column when condition met for two other columns

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

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