Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

DAX - Column content based on slicer selection

Hi folks, I've done some research on the forum and while some responses get close to what I need I can't quite find something that I can use.   I have a table which contains, amongst many fields, ...
Need Help
  • MFelix's avatar
    MFelix
    8 years ago

    Hi Anonymous,

     

    Did you had a measure or a calculated column?

     

    I'm assuming that since your data is always the same in the sample you showned that you created a calculated column, this will give you the maximum value of the date column in your data.

     

    Below you can see the same measure as you have but in a calculated colum (COLUMN_REF) and in a measure (MEASURE_REF) the only one that changes accordingly to the slicer is the measure.

     

     

    You need to change your formula to a measure instead of the column.

     

    Regards,

    MFelix

     

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Hi MFeliz,

I will test this as soon as I’m back at work tomorrow :) to answer your question, I would like to reference the value in REFERENCE DATE in several formulas and have a result dependant upon the filter.

Do you think that this solution will enable this?

Thanks,
OF
MFelix's avatar
MFelix
Icon for Super User rankSuper User
8 years ago

Hi Anonymous,

 

If you reference to this measure on the other formulas this will give you the expected result.

 

But be aware that using a measure is based on context so some of the formulas are not just simply using the measure you need to use aggregators or some filters in the new measures.

 

Regards,

MFelix