Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Problem with multiplying rows in table visual.

Hi guys,    i have a troubles with table visual and multiplying rows (unwanted) and i dont know where is the problem. Thank you for your time at first. My model look like this:    Thats sim...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi Anonymous ,

     

    This issue is because of 0 in return statement of your measure.

     

    Remove that isblank condtion and check.

    You will get exact rows as you want.

     

    Thanks & regards,
    Pravin Wattamwar
    www.linkedin.com/in/pravin-p-wattamwar

    If I resolve your problem Mark it as a solution and give kudos.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Anonymous ,

 

This issue is because of 0 in return statement of your measure.

 

Remove that isblank condtion and check.

You will get exact rows as you want.

 

Thanks & regards,
Pravin Wattamwar
www.linkedin.com/in/pravin-p-wattamwar

If I resolve your problem Mark it as a solution and give kudos.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi again, 

 

the same problem with growing number of rows happening in another 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])

 

Than i got thousands of rows. Why? 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 points i would be grateful. 

 

Have a nice day,

Tomas