Forum Discussion
Remove duplicates on Stacket column chart
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 ...
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
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
Thanks very much it helped a lot! 🙂