Need Help - Field Value Drop down

[gauravnarchal]

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.

[v-yangliu-msft]

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]

Hi @v-yangliu-msft - 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]

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]

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]

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