Forum Discussion
amarsale85
Helper II
6 years agoIntelligent summarizing
Hi Experts, How are you guys ? I am stuck at below scenario, Suppose I need to create a report which shows "Profit Amount by Location" where in Location dimension say "London" exists thrice, 1 ...
parry2k
Super User
6 years agoamarsale85 well you have to create a concatenated column, maybe City with Country to make it unique and in the slicer, you use City and select Londo, in visual you use this new concatenated column and you will see unique rows.
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡