Forum Discussion

stvn43's avatar
stvn43
Frequent Visitor
3 years ago

Count Unique Order by DistinctCount of Multiple Columns

I have a data set (one table) with lots of repeating values, but I need to define order types based on this data. To classify the order types, I need to get the distinct counts from three columns fo...
Need Help
stvn43's avatar
stvn43
Frequent Visitor
3 years ago

I modified the measure. Still not working:

Simple Order Types =
VAR SimpleOrderCount =
CALCULATE(
    DISTINCTCOUNT(orderTypeData[orderid]),
        FILTER(
        DISTINCTCOUNT(orderTypeData[groupid] < 2 && DISTINCTCOUNT(orderTypeData[destid] < 2 && DISTINCTCOUNT(orderTypeData[adid] < 2)
        ))

Return
SimpleOrderCount