Forum Discussion

ACraig08's avatar
ACraig08
Icon for Helper III rankHelper III
2 years ago
Solved

Conditional Dynamic Value in Text Box

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!!

Need Help
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    2 years ago

    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.

3 Replies

  • jdbuchanan71's avatar
    jdbuchanan71
    Icon for Super User rankSuper User
    2 years ago

    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's avatar
      ACraig08
      Icon for Helper III rankHelper III
      2 years ago

      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's avatar
        Anonymous
        Not applicable
        2 years ago

        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.