Forum Discussion
table visual rows increasing drastically after adding a measure
Hi All, I have 2 tables as shown below: Table1: Date 2024-07-07 2022-05-26 2022-05-25 2021-12-13 2021-12-12 Table2: EmpNo CompCode CompNo Valid From Valid To Salary 2572...
I had observed , when I am adding a field from different tables having relationship as one to many with my fact table then the number of rows are increasing. How can I make a change in DAX so that it should consider only relevant value from another table instead of considering all the values
- Also just to troubleshoot I have added measure2 "Is_LatestVersion" in table visual and it was showing value 1 for many records of fields from different tables. My expectation was the field should only show a result where Measure2 is 1, but the dax was first checking the whole data of a field and then it was providing a result, that's why the performance is decreased.
- When I am taking about a field, it is coming from different table having one to many relationship with my fact table