Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all! Hope all is well--
I am working on a report where i need to count Distinct OrderKeys (Orders) where they are late, based on specific warehouse (WHSE), and how late they are (Date Group). The problem I am running into is i wanted to create a measure using COUNT DISTINCT (as one orderkey can have multiple customers), but the set expression does not "change" when i filter on particular date groups.
Im trying to figure out how to write a measure that is not static, that will change when i select my date group filters filter--
count({<DayGroup={'1-7','8-14','14+'},WHSE={'Phoenix'}>}distinct Orders)
Probably you may want to remove DayGroup condition from the set expression if you want to make selections in the filter and wants to see the change