How we can find the mode of a dimension value (not key)?
When we use the Mode function it finds the most commonly-occurring value. For working with fact tables it's useful. For example, you can easily find the ID of the most repeated dimension row because the ID exists in the fact table. However, you are going to find the Mode for the name of that dimension, you face a problem. Since the mode function looks at the dimension table and says none of them repeated!
So, how we can find the mode of a dimension value (not key) with respect to how many times it repeated in the fact table?