How to Calculate Average for Rank.

[basirve]

Dear Experts,

I have claculated rank for score based on Job Desc, But i would like to create a measure to get average on top of rank based on Job Des.?

I/p

O/P:  Average of Rank by Job Description 

O/p

Please suggest me the solution for this.

Thanks & Regards,

Venkat

[basirve]

Dear Mathur,

We have created a mesaure to calculate for rank.

Regards,

Venkat.

[Ashish_Mathur]

Hi,

Share the link from where i can download your PBI file.

[Ashish_Mathur]

Hi,

If Rank is already a column in your dataset, then create a simple table visual and drag Job Description and Manager there.  Write this measure

Average rank = average(Data[Rank])

Hope this helps.

[Ashish_Mathur]

Hi,

Is the Rank a measure or a calculated column formula?  Share the link from where i can download your PBI file.

[richbenmintz]

Hi @basirve ,

I am sure this is to simple, but could you not just use the average function.

avg rank = average(table[rank])

 Are you able to provide a sample pbix file?

Thanks,

[daxer-almighty]

@basirve 

If you group by a field, the entries in the field should be correct, meaning that the same ideas should bear the same names. In the example above, you've got a mixture of different job descriptions which I understand mean the same thing, so slicing will not work correctly. Fix your data first. Make it uniform the way it should be.

[basirve]

Dear Almighty,

I Have updated the sample data here.

Thanks & Regards,

Venkat