How to Calculate Average for Rank.

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.

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,

Hi,

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

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.

Dear Mathur,

We have created a mesaure to calculate for rank.

Regards,

Venkat.