Forum Discussion
Help with Mutiple Filter options
Hi Lipao255,
I had done something similar longtime back. From your dataset, you could create another table with "imdb_id" and split the production countries which are seperated by comma.
Connect this table to your table (fact) with "imdb_id" as key. you could remove production countries in the fact table.
Below example.
From
Into
I also need help with how many movies or shows an specific country has produced. For example, Brazil ("BR") has 60 participations in movie productions.
However, its only counting 51 acurrences. What kind of dax formula can I use to solve this problem?
Hi Lipao255,
I had done something similar longtime back. From your dataset, you could create another table with "imdb_id" and split the production countries which are seperated by comma.
Connect this table to your table (fact) with "imdb_id" as key. you could remove production countries in the fact table.
Below example.
From
Into