User Profile
Emanuel
Helper I
Joined 6 years ago
User Widgets
Contributions
When filtering from slicer is not showing all the values
Hello, I need assistance in finding a solution to the issue I face. I have a table with project and a date dimention table. There is an active relationship between 2 tables on date column (date dimention table) and the initiated date (project table) and an inactive relationship between date column (date table) and the closed date (project table) I built 2 measures, one for created projects and the second for the closed projects. On the bar chart I use the 2 measures and shows the correct count for a specific month, however when I want to see the values in a matrix table it shows only the created ones. I don't understand why the closed ones are not shown in the matrix table. I figure it has to do with the active relationship however I can't have both relationship active. If anyone can help please do 🙂 Thank you, EmanuelRe: Check if value exists in another table based on a specific category
Thanks Li for your solution. How can I include this measure in a larger calculation? So, what I need is to create a measure/column for KPI that has to contain the following logic: If( Does it have a "Resolution Communication" work info type?=yes and Report_tgt_date<=Action Date then KPI is met else is not. I've added 2 colums to your solution to help with the outcome (I don't know why is not letting me to insert the bi file itself)
