Forum Discussion
Problem with multiplying rows in table visual.
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.
I meant that number of rows grow up by adding measure and columns from different tables or adding measure and filter by column from different table.
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.
Thank you,
you helped me a lot. 🙂
Have a nice day,
Tomas
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
- Link is not opening.
The link include url address "https://smlouvy.gov.cz/smlouva/" and ID of document version. So for example: https://smlouvy.gov.cz/smlouva/11740864