Unique RAnkx bill

[Anonymous]

Hi all..

I need your help, i have this table:

  

Only show 1 client, no repeat the rankx.

Thx so much for ur help.

[Ashish_Mathur]

Hi,

Are you looking at writing a calculated column formula or a measure?  Also, there are 3 rows for 150, 1650 and 24/4/2018.  Why have you show the rank for the seond row (why not for the first and third row)?

[Anonymous]

Sorry i have a mistake...

is a calculated column... 

[Ashish_Mathur]

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]

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]

Hi,

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

Hope this helps.

[Anonymous]

@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]

Hi,

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

Dates = MIN(Data[Date])

Here is the visual