Forum Discussion
power bi desktop
Hello All, I have a dimension table that has client name and intouch id column. Also I have other fact table that contains clients other information and am filtering them through Report Level Filter...
v-lili6-msft
Community Support
Community Supporthi, Anonymous
The logic of a measure and column is not the same, so don't put them into together.
For your case, It's better to use virtual data to create a simple sample pbix file and share with us to test, that will be a great help for the case.
Best Regards,
Lin
Hi v-lili6-msft
I can tell you that all the table2 is extracted from table 1 that has client details, Id and other columns. and each client name has no of records. So there is repetition. But table2 has only the distinct client names and their id . Both are connected by id and in report level filter i am using Client name of table1.
regards
Chahat