Cannot drag and drop to the Values data field

[M4r3]

I have issues when I try to drag and drop Fields to the Values data field in the visual. This is the case when I try with the normal column and also with a calculated column. If there is a field already in the Values and I remove it, and then try to insert the same field, it still doesn't work.

This issue started this week. Version: 2.107.683.0 64-bit (July 2022)

[M4r3]

For example how is it possible that removing this field works, and when I try to insert the field in values again, it doesn't want to drag and drop? I can insert it in details, but not in values.

[Anonymous]

Hey there! I have the similar issue. Im able to remove a field(contains text, not numerical or calculated) but cannot place it back. Fields section doesnt accept neither the old field nor the new one as if I wasnt able to drop it within the given area.

Version: 2.107.683.0 . Would be great to know what is going on and how to tackle it 

[SpartaBI]

@Anonymous someone created a calculation group on the model which blocks the usage of implicit measures going forward. You can't have both and in general it's best practice to create explicit measures instead of dragging the columns to be aggregated implicitely 

[SpartaBI]

@M4r3 I will pm you

[M4r3]

@SpartaBICould you explain a bit further? I did not create a calculation group.

This EUR_AMOUNT column is just a calculated column containing only numerical values.

EUR_AMOUNT = IF(CLM_C_PAYMENT_SAT[CURRENCY_CODE]="HRK",CLM_C_PAYMENT_SAT[AMOUNT]*0.13,CLM_C_PAYMENT_SAT[AMOUNT])

[SpartaBI · Accepted solution]

@M4r3 looks like the implicit measures is disabled. Did you create a calculation group? That enforces the disable of implicit measures so you will need to create explicit measures for that columns and then you could put them in the values