Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
@Anonymous
You may Use performance analyzer in Power BI Desktop to check query and take a look at SUMMARIZECOLUMNS.
@Anonymous
You may Use performance analyzer in Power BI Desktop to check query and take a look at SUMMARIZECOLUMNS.
This is how model on Visual Studio looks:
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
101 | |
86 | |
64 |