Forum Discussion

paterke's avatar
paterke
New Member
2 years ago

Calculated dimensions possible?

Hi

I have 10+ years of Qlik experience and they have a feature that I used a lot ... calculated dimensions. That is an expression that can be used as a dimensions. e.g.: calculated dimension = number of product each client bought, expression = number of clients.
You'll get a result like this 

number of product each client boughtnumber of clients
1564
2178
3654


As this is a dimension you can select a 2 and you have selected the 178 clients.

After selecting a few products, that table would dynamically adjust and recalculate the dimension.

Is this possible in Power BI? 
Making a selection on that dynamic dimension isn't necessary for me at this moment. But recalculating the dimension after a selection would already be nice 🙂




 

Need Help

1 Reply

  • some_bih's avatar
    some_bih
    Community Champion
    2 years ago

    Hi paterke I am not using Qlik, still it is possible to create statistics about number of clients or number of clients bought.

    Example is how many distinct customers bought some brands, check link.

    In PowerBI usually model is needed and measures to show "numbers".

    Hope this help