Forum Discussion

SwaroopShankar's avatar
SwaroopShankar
Frequent Visitor
6 years ago
Solved

measure if column value is a certain text

Hi,   Please see below data for your refernce.    I need to get a Measure which concatenates 'Pic' column based on 'Name'.   Basically, IF('Name'="Site Photo 1", CONCATENATE('Pic') using ...
Need Help
Tips and Tricks
  • gpoggi's avatar
    gpoggi
    6 years ago

    Hi my friend, you can apply filter you need, for example if you try this:

     

    MyMeasure = 
IF (   
    SELECTEDVALUE('Table'[Name]) = "My Photo1.png",    
    CONCATENATEX (
        'Table',
        'Table'[Pic],
        "",
        'Table'[Index], ASC
    ),""
)

     

    When you have 4 values it will fill the concatenation only if selected Name is "My Photo1.png":

    So you will get the same behavior if you try with an slicer and a card, the card will fill the concatenation only if the name "My Photo1.png" is selected.

     

    Give it a try and let me know if it works.

     

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

     

    PS: There is a current contest in this community I'm participating in, if you like it I'll appreciate your Kudo in this link:

     

    Better-Together-T-Shirt-Contest 

     

    Regards,

     

    Gian Carlo Poggi

edhans's avatar
edhans
Community Champion
6 years ago

Is this really a measure, or is it a calculated column, or is this a custom column in Power Query?

 

I'm not a programmer. What does  CONCATENATE('Pic') using 'Index' do? what is your expected output?

 

To just combine fields in Power Query, you just use [field1] & [Field2]

 

DAX is different, but need to understand the terms you are using. And you did post this in the Power Query forum, so that is why your use of the word "measure" has thrown me a bit.

SwaroopShankar's avatar
SwaroopShankar
Frequent Visitor
6 years ago

My apologies for the confusion. I am fairly new to the Power BI community.

 

I need the end result to be a Measure and not a column.

 

CONCATENATE combines 2 or more values together. I want the order in which it compiles these values to follow the 'Index' values (small to big)

 

I can not use [Field 1] & [Field 2] technique because I have a lot of these values and the number of values change based on the image size. 

 

Please help.