Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Mark_Berry
Helper I
Helper I

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

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. 
ReferenceDescription
Lot#1Information                    
Lot#2Information                    
Lot#3Information                    

 

ReferenceDescription
Questions#1Information                    
Questions#2Information                    
Questions#3Information                    


2 REPLIES 2
Mark_Berry
Helper I
Helper I

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

ReferenceDescription
Lot#1Information                    
Lot#2Information                    
Lot#3Information                    


When Question is Selected

ReferenceDescription
Questions#1Information                    
Questions#2Information                    
Questions#3Information   
Daniel29195
Super User
Super User

@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

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.