Problem with unwanted growing number of rows

[Anonymous]

Hi guys, 

i have problem with growing number of rows happening in model which is stored in Visual Studio. 

When i am in PBI Desktop in table visual, same thing like last time happend. If I have there coulmns from table "Smlouvy" and one from "VerejnopravniOrganizace" everything is fine. I am using slicer based on column "Organizace" from table "VerejnopravnOrganizace" to filter it. It shows me 13 rows. Great.

But problem happens when i add measure which looks: 

URL_RS:= "https://smlouvy.gov.cz/smlouva/" & MAX('Smlouva'[IDverze])  - so the final url is something like this: https://smlouvy.gov.cz/smlouva/6197507 

Than i got thousands of rows. Why?

Note: When i have same table only with this measure (no columns from foreign tables), everything works fine. Is there problem with measure or relationship between tables?

If you have any tips or advice i would be grateful. 

Thank you for your time and have a nice day,

Tomas

[v-chuncz-msft · Accepted solution]

@Anonymous 

You may Use performance analyzer in Power BI Desktop to check query and take a look at SUMMARIZECOLUMNS.

[Anonymous]

This is how model on Visual Studio looks: