Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Unique RAnkx bill

Hi all..   I need your help, i have this table:      Only show 1 client, no repeat the rankx.   Thx so much for ur help.
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Sorry i have a mistake...

 

 

is a calculated column... 

 

Ashish_Mathur's avatar
Ashish_Mathur
Super User
8 years ago

Hi,

 

Why do you want it as a calculated column and not as a measure?  The problem with a calculated column is that the calculation does not refresh when a filter/slicer selection is made in any visual.

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hi.

     

    the final result will be shown in a table visual, with more fields. So I do not know what would be the correct form if column or measure .. And slicers too..

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Super User
      8 years ago

      Hi,

       

      It should defeinnitely be a measure.  Download the file from here.

       

      Hope this helps.

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        Ashish_Mathur Thx for ur help, the measure works fine, but when i add more fields in visual, the rankx no works fine... can u help me plz (i want to add 7 columns in mi visual..)

         

        for example:

         

         

         

         

        Thx so much for u help