Remove duplicates on Stacket column chart

[Anonymous]

Hello,

I have a pbix which is supposed to show how many requests are sent to shared mailbox. For that every subject needs to be deduplicated before putting in on chart.

For now I have a stacked column chart with number of distinct subjects every day but I need to make it stacked column chart with number of distinct values overall just as outlook shows conversations so if the same subject was sent in several days it should be only counted on last date.

I tried to make a measure to eliminate duplicates and then putting it on chart but it doesn't work, how should I change it to make it work?

[Kedar_Pande · Accepted solution]

Measure:

LastOccurrenceCount = 
CALCULATE(
DISTINCTCOUNT(YourTable[Subject]),
FILTER(
YourTable,
YourTable[Date] = CALCULATE(MAX(YourTable[Date]), ALLEXCEPT(YourTable, YourTable[Subject]))
)
)

Add this measure to your stacked column chart to show distinct subjects, counted only on their last occurrence date.

If this helped, a Kudos 👍 or Solution mark would be great! 🎉
Cheers,
Kedar
Connect on LinkedIn

[Anonymous]

Thanks very much it helped a lot! 🙂