Forum Discussion

gauravnarchal's avatar
gauravnarchal
Post Prodigy
5 years ago

Need Help - Field Value Drop down

Hello 

 

I don't know why I don't see the below options in my PBIX anymore. I used to see this earlier and not anymore.

 

Is there any setting from where I can enable this?

 

Before I use to see all the options when a column with the number was added to the field value.

 

 

 

Currently, I can only see the below options.

 

 

Need Help
Show and Tell

5 Replies

  • mwegener's avatar
    mwegener
    Most Valuable Professional
    5 years ago

    Hi gauravnarchal ,

     

    can it be that the second option is from a measure? (Calculator icon in the field list.)

    Here the aggregation (calculation) is already defined in the DAX formula.

     

    • gauravnarchal's avatar
      gauravnarchal
      Post Prodigy
      5 years ago

      Hi mwegener  - The field value is not a measure but a number column in the table. I'm still not able to figure out what could be the issue.

      • mwegener's avatar
        mwegener
        Most Valuable Professional
        5 years ago

        gauravnarchal, can you share some screenshot where we can get a better overview of the data types and data model?

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi  gauravnarchal ,

    1. If the value above is measure, the aggregate function will not be displayed.

    2. If the value shown above is a calculated column, it will show the functions that can be aggregated in this field.

    Measure itself is defined in the Dax function and aggregated. As long as you write the measure, you must add Max or Sum in front to bring out the column, so the aggregation will not be displayed in Value.

     

    Best Regards,

    Liu Yang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

    • gauravnarchal's avatar
      gauravnarchal
      Post Prodigy
      5 years ago

      Hi Anonymous - The field value is not a measure but a number column in the table. I'm still not able to figure out what could be the issue.