Conditional Dynamic Value in Text Box

[ACraig08]

Hello! So you know how you can add a dynamic value inside of a text box:

I have been trying to find anything that provides documentation or a video tutorial on how to use this but nothing. 

I have a table like this:

Table Name: Added Project Count

I want to be able to put a dynamic value in there to call the project count based on the district. So my text box would look like this:

8 added in D1

8 added in D2

6 added in D3

7 added in D4

...

But I can't seem to figure out how to reference a specific table and column and it's value. Any help, whether it is how to actually do it or a link to documentation about this, would be SO AMAZING!!

[jdbuchanan71]

@ACraig08 

I think this will give you what you are looking for.

Concat = 
CONCATENATEX (
    'Added Project Count',
		CALCULATE ( SELECTEDVALUE ( 'Added Project Count'[Project Count] ) ) & 
		" added in " &
		CALCULATE ( SELECTEDVALUE ( 'Added Project Count'[District] ) ),
    UNICHAR ( 10 ),
    CALCULATE ( SELECTEDVALUE ( 'Added Project Count'[District] ) )
)

[ACraig08]

So is there no way to do it within the "Ask a question about your data" box so it's one district at a time and I can edit the formatting. 

[Anonymous · Accepted solution]

Hi @ACraig08 

I suggest that you can put the results you want into a card visual.

DAX:

Measure = SELECTEDVALUE('Table'[Project count])&"  added in  "&SELECTEDVALUE('Table'[District])

Result:

At the same time, you can also modify the format of the card visual.

Best Regards,

Jayleny

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.