Forum Discussion

amarsale85's avatar
amarsale85
Helper II
5 years ago

Intelligent 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 in England, 1 in Ontario (Canada), 1 in Arkansas (USA).

Now the problem is if select filter, Location = "London" to see "Profit Amount", I see single row of summarized data of all three cities which isn't correct. Or should this behavior be accepted as it is ?

 

Please help.

 

4 Replies

  • parry2k's avatar
    parry2k
    Super User
    5 years ago

    amarsale85 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.⚡

     

  • v-lionel-msft's avatar
    v-lionel-msft
    Community Support
    5 years ago

    Hi amarsale85 ,

     

    Has the ‘Profit Amount’ of the three cities with the same name been aggregated?
    If so, you may need to label the three cities separately to make them unique.

    Please share sample data and screenshots of visuals.

     

    Best regards,
    Lionel Chen

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • amarsale85's avatar
    amarsale85
    Helper II
    5 years ago

    Thank you Everyone 🙏🙏 for comments. This was already explained and again I did explained this and unfortunately adding suffix/prefix to the location or adding country/province on the report to make it unique is out of question.

     

    So my question is, is there a way to add invisible characters in location name (Like "London") to make it unique ? 

     

    Thank you,

    Amar