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

     

MFelix's avatar
MFelix
Icon for Super User rankSuper User
8 years ago
Hi Anonymous,

Can you share the measure you created?

Regards,
MFelix
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Here it is:

 

DATE_REFERENCE_CREATION =
SWITCH(
     TRUE(),
     MAX('Slicer Table'[CREATION DATE])="REQUISITION",MAX('Receipts & Overdues'[CREATION_DATE_REQ]),
     MAX('Slicer Table'[CREATION DATE])="PURCHASE ORDER", MAX('Receipts & Overdues'[CREATION_DATE_PO]),
     MAX ('Receipts & Overdues'[CREATION_DATE_REQ])
     )

  • MFelix's avatar
    MFelix
    Icon for Super User rankSuper User
    8 years ago

    Hi Anonymous,

     

    Do you have any Calendar Table or something similar connecting to you data table?

     

    Regards,

    MFelix

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      No nothing at all, only one SQL and its table loaded in the model

      • MFelix's avatar
        MFelix
        Icon for Super User rankSuper User
        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