Intelligent summarizing

[amarsale85]

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.

[amarsale85]

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

[Ashish_Mathur]

Hi,

Drag the Country as well to the visual.

[v-lionel-msft]

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.

[parry2k]

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