Forum Discussion
Mark_Berry
Helper I
Helper ICreate 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 whi...
Mark_BerryHelper I
Helper IData 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 |