Convert text column to measure

[Anonymous]

Hey guys, 

I have a text column (values, such as 201, 203, F453 etc) and I want to convert that to measure in order to use it in another measure. 

I specifically need those three values to be filtered. How can i do that in dax?

Sona

[KNP]

Hi @Anonymous,

You haven't really provided enough info to answer this question.

What kind of measure do you need? Do you want to count the values? Do you want to SUM the values? What do you mean by "need those three values to be filtered?

Check this post for some tips on getting your questions answered.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1891875#M725989  

Regards, 

Kim

[Anonymous]

I need to create a measure that would just filter for those activities. 

Something like this:

Measure=if(activity=201 || activity=203 || activity=F453), "Yes", "No")

Sorry for the confusion,

Sona

[PaulDBrown]

Try:

Filtered activity =
IF(MAX(Table[Activity]) IN {"201", "203", "F453"}, "YES", "NO")

[KNP]

I would add a column first instead of a measure. You could do this in DAX or PowerQuery, and then use that in your measure.

PBIX file.

https://drive.google.com/file/d/1-1RBu2XQ7h8flUy-b2nxg7gDHEgxo1AW/view?usp=sharing 

[Anonymous]

The problem is that if I create a column, I cant use it in a measure. When I type it, it does not come up in the measure. 

Sona

[AlexisOlson]

This is likely because you usually need to aggregate columns in a measure. If you write measure1 = Table1[Column1] then it doesn't know which value(s) in that whole column you want, so you need to use some sort of aggregating function like measure1 = SELECTEDVALUE ( Table1[Column1] ).

[KNP]

Sorry, I think you may need to take the time to explain your scenario a little better.

Provide some sample data, or a sample PBIX file that shows your issue, and your expected outcome.

[Anonymous]

Thanks a lot!

I created super simple data similar to the actual one. 

So, I need to calculate the count distinct of application ID, when (Activity is 201 or 203)  or measure is 1. So, I need to have everyone that hit the measure as 1 or they have activity 201 or 203. 

File: https://drive.google.com/file/d/1Cs9iYD91TXdketi2gshwxQLsF93AMeqD/view?usp=sharing 

Thanks, 

Sona 

[PaulDBrown]

@Anonymous 

Can you make the link public? it is requiring a login