Populate row with text based on the filters of a measure

[Anonymous]

Hi All,

I am trying to create a column that will populate rows based on the filters I have placed on a measure.

I hope this is actually something that can be done

So the data set I have measures prospective customers, and tracks their movements from one status to another

e.g:

Customer	Users	Date Warm	Date Hot	Date Dealt
A	12	12/3/19
B	13	13/4/19
C	4	10/2/19	15/5/19
D	5	12/12/18	14/4/19
E	9	15/2/18	15/19/18	9/1/19
F	3	12/2/18	3/9/18	1/10/18

I have created a measure that will sum up the customer, based off of what their "status is"

e.g: 

WarmSum = CALCULATE(SUM('Table'[Customer]), 'Table'[Date Warm] <> BLANK(), 'Table'[Date Hot] = BLANK(), 'Table'[Date Dealt] = BLANK())

I now want a column that will put the text "Warm" into a new column, i also need this to update as the customer changes status

I need to do this as I want to put this into a Map visual which will then show me how many potential customers, by status we have.

I hope this makes sense

Thanks in advance

Edit: I have updated the example table so it makes more sense

[Anonymous · Accepted solution]

I have managed to solve this issue

this can be done through a bunch of IF statments

Status = IF( NOT ISBLANK( 'Table'[Date Warm]) && ISBLANK ('Table [Date Hot] && ISBLANK('Table'[Date Dealt], "Warm,

IF( NOT ISBLANK('Table'[Date Hot]) && ISBLANK('Table'[Date Dealt]), " Hot"))

This then populates the column with the text value I needed

[cnweke]

Hi,

I actually don't really get what you're trying to do but I can say the following:

I don't know how much control you have over your data source but wouldn't just having 3 columns being customer, the value and status be a lot more intuitive? Status would have 3 values: warm, hot, dealt. This simplifies everything, you have less columns and you no longer have to play around will null values.

If your data isn't in this shape yet maybe you should transform it first with Power Query and then do calculations with Dax. It'll save you a ton of time.

[Anonymous]

Hi @cnweke ,

Thank you for your response,

Unfortunately the data needs to be in this format as the product is quite slow moving, so we need the ability to track how long each customer stays in each status.

I need to create this column to act as a kind of heat map for each country