Remove duplicates from a visual

[Anonymous]

Hi Team, 

quick question. I have a visuals with an incredible number of duplicates. this is due to the query behind that expands many periods and then some other functions add up more junk to the visual, therefore i need something to narrow down:

the important thing is that for every market there is a TP1, TP2, TP3 and so on if necessary, but the rest can go.

is there anyway to fix this?

[v-frfei-msft]

Hi @Anonymous,

Are the NPR vLY% and PAX vLY% measures? Kindly share your pbix to me or you can share your sample data and the formulas.

Regards,

Frank

[Anonymous]

Hi Frank, 

no they're column. 

I can't share the file as data can be sensitive 😞

but basically, at query level there are some period ranges (date from - date to) expansions into single day to rematch with NPR, and PAX and so on. that's why there are so many repetition.

Sometime data is lacking tho (like in this case) so it presents the repetition but with no data. 

hope it was clear