User Profile
lipao255
Frequent Visitor
Joined 4 years ago
User Widgets
Contributions
Help with Mutiple Filter options
Hello, everyone. I downloaded a NetFlix dataset wich contain a lot of movies and shows details. From description, imdb score, imdb votes, production countries, and so on. I've almost finished the dashboard, however I cant find a solution for filter options. As you can see "Genres" filter option has many values, like "Action", "Action, Animation", "Action, Sci-Fi", etc. I don't like this. I want to create a filter option with single values, like "Action", "Animation", "Sci-fi" etc. And when the user selects "Action" it will show all movies and shows that contains "Action", and also the ones like "Action, Animation". This problem also happens with "Country Productions" filter. How can I solve this issue? Thank You.Help creating a dax measure (excluding a specific column from table)
I'm practicing my Power BI skills. I've downloaded a csv file which contains data about olympic games. The dataset has many columns, such as country, athlete name, year, sport, event, medal which the athlete has won, olympic city, etc. The problem is that I want to create a bar graph that display country name by medal types count. However if create a graph "Country" by "Medal" from original csv it will not display the correct numbers of medals, because if a country wins a medal in a team sport (like volleyball or football) it should count as only one medal, and not the sum of all medals of all athletes in that team. This could be solved by removing Athlete column and selecting distinct values of "Event" collumn, like creating a table using the following formula: Table 2 = CALCULATETABLE(ALLEXCEPT('summer (3)','summer (3)'[Athlete]),DISTINCT('summer (3)'[Event])) However, I don't want to create a new table, because I would have serious problems with relationship between them (I have no idea how to do it, to be honest). So I want to create a measure. I created the following measure: Medal count = COUNTX(CALCULATETABLE(ALLEXCEPT('summer (3)','summer (3)'[Athlete]),DISTINCT('summer (3)'[Event])),'summer (3)'[Medal]) It is showing the correct number of all medals in olympic games history (untill 2012). However, for every country, its showing the number of gold medal, silver medal and bronze medal with the same number (the total number of olympic medals 14753). It's not filtering by the number of rows for that specific country. The same number also appears if I select any medal type from filter option (Gold, Silver or Bronze). I have no idea how to fix this. How can I create a measure that shows the correct number of medal type for every country?Create a bar chart using distinct values of an specific collum (DAX?)
I'm practicing my Power BI skills, thus I've downloaded a csv file which contains data about olympic games. The dataset has many columns, such as country, athlete name, year, sport, event, medal which the athlete has won, city, etc. The problem is that I want to create a bar graph showing country name by medal types count. However if I just select the columns the graph will not display the correct numbers of medals, because if a country won a medal in a team sport (like volleyball or football) it should count as only one medal, and not the sum of medals of all athletes in that team. This could be solved by removing Athlete column and selecting distinct values of "Event" collumn. I tried to create a measure like Medida2 = DISTINCT(SELECTCOLUMNS('summer (3)', "EVENT", 'summer (3)'[Event])) and tried to apply on "Tool types" , but it doesn't work, an error shows up. Is there a way to do this with DAX language using Measures? I don't want to create a new table, because I have no idea how I would create relationship between these 2 tables. Specially because I will have some filters on dashboard.
