Return a text value

[NumeritasMartin]

Hello All,

After a little break from PBI I am trying to make a simply dashboard which is mostly working except for the text elements. I want to show the sector of a company, but am either returning an error or the column header as opposed to data. The structure of the table looks as below.

The measure I am trying to get to work looks as follows:

Sector = VAR SelectedAsset = SELECTEDVALUE('Values'[Asset])
RETURN
   IF(
          ISFILTERED('Values'[Asset]) && NOT(ISBLANK(SelectedAsset)),
          CALCULATE(
          VALUES('Values'[Profile]),
          'Values'[Asset] = SelectedAsset
),BLANK()

)

_Measure	_Year	_Period	_Day	_Fund	_Asset	_Profile	_Version	_Account	_Currency	_value
Meta Data	Undefined	Undefined	Undefined	Undefined	Campagnolo	Company Name	Actual	Undefined	Undefined	Sample data
Meta Data	Undefined	Undefined	Undefined	Undefined	Campagnolo	Deal Leader	Actual	Undefined	Undefined	Sample data
Meta Data	Undefined	Undefined	Undefined	Undefined	Campagnolo	Industry	Actual	Undefined	Undefined	Sample data
Meta Data	Undefined	Undefined	Undefined	Undefined	Campagnolo	Sector	Actual	Undefined	Undefined	Text I want to return
Meta Data	Undefined	Undefined	Undefined	Undefined	Campagnolo	Business Description (Long)	Actual	Undefined	Undefined	Sample data
Meta Data	Undefined	Undefined	Undefined	Undefined	Campagnolo	Headquarters	Actual	Undefined	Undefined	Sample data
Meta Data	Undefined	Undefined	Undefined	Undefined	Campagnolo	Geography	Actual	Undefined	Undefined	Sample data
Meta Data	Undefined	Undefined	Undefined	Undefined	Campagnolo	Operations	Actual	Undefined	Undefined	Sample data
Meta Data	Undefined	Undefined	Undefined	Undefined	Campagnolo	Website	Actual	Undefined	Undefined	Sample data
Meta Data	Undefined	Undefined	Undefined	Undefined	Campagnolo	Reporting Currency	Actual	Undefined	Undefined	Sample data
Meta Data	Undefined	Undefined	Undefined	Undefined	Campagnolo	Stock Ticker	Actual	Undefined	Undefined	Sample data
Meta Data	Undefined	Undefined	Undefined	Undefined	Campagnolo	Acquisition Date	Actual	Undefined	Undefined	Sample data
Meta Data	Undefined	Undefined	Undefined	Undefined	Campagnolo	Asset Status	Actual	Undefined	Undefined	Sample data
Meta Data	Undefined	Undefined	Undefined	Undefined	Campagnolo	Business Description (Short)	Actual	Undefined	Undefined	Sample data
Meta Data	Undefined	Undefined	Undefined	Undefined	Campagnolo	Exit multiple of cost - Manager's Current Estimate	Actual	Undefined	Undefined	Sample data
Meta Data	Undefined	Undefined	Undefined	Undefined	Campagnolo	Expected Exit Date	Actual	Undefined	Undefined	Sample data
Meta Data	Undefined	Undefined	Undefined	Undefined	Campagnolo	ITES - Paragraph 1	Actual	Undefined	Undefined	Sample data
Meta Data	Undefined	Undefined	Undefined	Undefined	Campagnolo	ITES - Paragraph 2	Actual	Undefined	Undefined	Sample data
Meta Data	Undefined	Undefined	Undefined	Undefined	Campagnolo	ITES - Paragraph 3	Actual	Undefined	Undefined	Sample data
Meta Data	Undefined	Undefined	Undefined	Undefined	Campagnolo	ITES - Paragraph 4	Actual	Undefined	Undefined	Sample data
Meta Data	Undefined	Undefined	Undefined	Undefined	Campagnolo	ITES - Paragraph 5	Actual	Undefined	Undefined	Sample data
Meta Data	Undefined	Undefined	Undefined	Undefined	Campagnolo	ITES - Paragraph 6	Actual	Undefined	Undefined	Sample data
Meta Data	Undefined	Undefined	Undefined	Undefined	Campagnolo	Lead Fund	Actual	Undefined	Undefined	Sample data
Meta Data	Undefined	Undefined	Undefined	Undefined	Campagnolo	Local Currency	Actual	Undefined	Undefined	Sample data
Meta Data	Undefined	Undefined	Undefined	Undefined	Campagnolo	Local Currency - Actual	Actual	Undefined	Undefined	Sample data
Meta Data	Undefined	Undefined	Undefined	Undefined	Campagnolo	Local Currency - Flash	Actual	Undefined	Undefined	Sample data
Meta Data	Undefined	Undefined	Undefined	Undefined	Campagnolo	Number of Employees	Actual	Undefined	Undefined	Sample data

[v-yiruan-msft · Accepted solution]

Hi @NumeritasMartin ,

Please update the formula of your measure [Sector] as below and check if it can return your expected result...

Sector =
VAR SelectedAsset =
    SELECTEDVALUE ( 'Values'[Asset] )
RETURN
    IF (
        ISFILTERED ( 'Values'[Asset] ) && NOT ( ISBLANK ( SelectedAsset ) ),
        CONCATENATEX (
            FILTER ( 'Values', 'Values'[Asset] = SelectedAsset ),
            'Values'[Profile]
        ),
        BLANK ()
    )

If the above one can't help you get the expected result, please provide some raw data in your table 'Values' (exclude sensitive data) with Text format and your expected result. It would be helpful to find out the solution. You can refer the following link to share the required info:

How to provide sample data in the Power BI Forum

And It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.

How to upload PBI in Community

Best Regards

[MFelix]

Hi @NumeritasMartin ,

The example is not explicit enough can you give some more insights on what you are trying to achieve.