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

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 

     

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Super User
      8 years ago

      Hi,

       

      If you wish to show date also in the visual, then add this measure

       

      Dates = MIN(Data[Date])

       

      Here is the visual