I'm struggeling with a measure I need for a tooltip. In my scenario I have a calendar with important holidays etc, and I'm currently working on a weekly graph. My calendar has one row for each day, and a column named Holidays. I want to concatenate only the unique values from the calendar to this measure so that if I drill down to daily graph there will say "Easter" in the tooltip every day. When you don't drill down and have weeks in the x axis I want it to show "Easter" only ONE time. With my current measure the tooltip shows "Easter" seven times for the week of easter this year.
Example: During easter my calendar would look like this:
My current measure:
Holidays = CONCATENATEX(FILTER('MyCalendar';'MyCalendar'[Holidays] <> BLANK()); 'MyCalendar'[Holidays];",")
My current output in tooltip:
Easter, Easter, Easter, Easter, Easter, Easter, Easter
My wanted outcome:
By the way: some weeks (and months if you drill up) have several unique Holiday values, the "First function" is thus not what I am looking for.
Is there anyone out there who can help out?
Solved! Go to Solution.