Forum Discussion
Eliminate Duplicates
I'm sure I have much to learn and enjoy. I've heard it from the Power Apps geek, the SharePoint geek, now a magnanimous Power BI person. 😁
I opened the 'Count of Park', couldn't find a 'distinct' option. Also, my concern is not a repretition at the park level or of the park names themselves, it is with the CQTitles. For example the system is storing all Fitness Test; a member has to pass a Fitness Test every year. I only want the BI graph to query and return data on the Member's most recent, not all of their Fitness Test. Here is in opened CQTitle. Should I make your recommended change here? If yes, what/how? Thanks!
Back to you 'pull down and pick" suggestion; won't that simply ONLY show me those that I've newly selected? Meaning, if any of the newly selected are repeats of the same CQTitle, just from an early year, they will still show up in the query based on this action, yes? Meaning I will still see every 'Fitness Test' associated with a Member if I only chose 'Fitness Test' as the "pull down" filter choice, yes? If yes, this is what I am trying to avoid. I DO NOT want the Region (PWR, NER, SER, etc.) Totals to include ANY duplicate 'qualifications' - only the most recent qualifications and all of the certifications (certifications are only issued once, so there would natually only be an impact of one on the total; whereas qualifications, if duplicates are not filtered out would have an impact of multiples.
All CQTitles of "Fitness Test", "Medical" and "Self-Contained Breathing Apparatus Fit Test" should only be counted once/the most recent; all other similar qualifications from earlier years should not factor in the overall "Compliance" totals?
I hope this makes sense.