Pass Filter context of measure into the calculated column in DAX

[jimmymitra]

Hi Friends , 

My apology if the question has been asked in the forum already , I tried to search , but could not find one. 

Here is my question - 

I have a measure M1 that calcuates number of distinct "Currency Code" based on the filters selected in the slicers. 

Based on the measure I am creating a calculated column called "FinalCurrency" 

The requirement is if the value of M1 is 3 , then the calculated column "FinalCurrency" will have "Euro" ,else "Other"

But my problem is two fold - 

1. In calculated column , if I use the measure M1 ,it does not carry the filter context selected by the user , instead it considers the entire table data , how do I pass the filter context of the measure M1 in the calculated column

2. Is there a way I can create a non-numeric measure , e.g. Measure M2 to have value "Euro" if M1 = 3

In that case I will not have to create a calculated column

Hope I could able to make myself clear in my question

Thanks in advance for your kind reply

[OwenAuger · Accepted solution]

Hi @jimmymitra

Answering your questions:

1. No - calculated columns are computed at refresh, so cannot take into account slicer selections or filters of any kind.
2. Yes you can create a measure returning a text string, such as
   

   M2 =
   IF ( [M1] = 3, "Euro", "Other" )

   This measure will work in general, but there is a possibility you would have to wrap the expression in CALCULATE(..., ALLSELECTED() ) to ensure it returns the same value in all filter contexts within a particular report page (sounds like that's the behaviour you need).

Regards,

Owen