Forum Discussion
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 simplified model of course.
And this is how looks the table visual:
Now when all the columns are from table "dimDocument", there is no problem.
This is how looks table when use slicer (on the left), which is based od table "dimDocument".
Still working fine.
But then i need to add measure (from table dimDocument) in my table and this is whats going to happen:
The rows multiply. Instead of 24 rows i got 9915 rows (what is equivalent to previous number of rows before using slicer = number of all rows in "dimDocument" table). What happend?
This is how measure looks:
When i use slicer on "dimDocument" table, everything looks fine and i get 24 rows -->
Similar problem happens when i use in my table column --> Organization from "dimOrganization". Then rows multiply nine times for each document (there is nine different values in column Organization in table "dimOrganization"). I would expect 24 rows with value "Technické služby" in column Organization in my table.
This is result:
Same behavior happens when adding column "JevSouladu" from table "factOvereniSouladu" (instead of column Organization from "dimOrganization"). But this time the rows multiply three times (there are 3 possible items in column "JevSouladu" from table "factOvereniSouladu"). But on first document --> Document number "OBJD20200010" --> there are only 2 items ("Ano" and "Nelze určit") from 3 possible items ("Ano", "Ne", "Nelze určit").
Check it:
Is anybody able to tell me why is it behaving so weard? Or am i using my model not properly? I would like to understand the behavior/procceses behind that.
If i use only columns from table dimDocument and measures from any table together --> everything works good.
Thank you guys,
Tomas
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.
7 Replies
You mentioned, the issue with Multiply. I do not see any formula having Multiplication.
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.
