Add column with a dynamic values

[upiotrowska]

Hello, 

I have two tabled dim_company with company_id, company_name....

and fact_company with company_id, date and metrics like eg visits.

I need to add a column in the dim table with a ranking by number of visits. So company with the highest number of visits should be 1, ect. When I change values in a date slicer on a dashboard I want the values in Rank column to change accordingly and take into account only sum of visits within a given time rane.

How can I create this column?

Best

[vicky_]

You cannot do this with a calculated column, as those are not affected by the slicers on your dashboard, and will only be updated at refresh time. Instead, consider using a measure - SQLBI has an article on how to achieve that here: https://www.sqlbi.com/articles/use-of-rankx-in-power-bi-measures/