Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Cannot drag and drop to the Values data field

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)

  • Anonymous 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

6 Replies

  • SpartaBI's avatar
    SpartaBI
    Icon for Community Champion rankCommunity Champion

    Anonymous 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

  • Anonymous's avatar
    Anonymous
    Not applicable

    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])
  • Anonymous's avatar
    Anonymous
    Not applicable

    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's avatar
      Anonymous
      Not applicable

      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's avatar
        SpartaBI
        Icon for Community Champion rankCommunity Champion

        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