Forum Discussion

SammyNed's avatar
SammyNed
Icon for Helper I rankHelper I
4 years ago

Summarize by 2 columns

Hi guys,   Need some assistance please. This is long winded, but I have the following table, simplified below. Basically customer ID's, date of order and order category. I want to know how many cu...
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

SammyNed , You can use date and month year from date table, if you are using that in visual 

 

Try measure like

 

countx(filter(summarize(Table, Table[Customer],"_1", calculate(distinctcount(Table[Date]))),[_1] >1),[Customer])

 

or

 

 

countx(filter(summarize(Table, Table[Customer], Table[Month Year],"_1", calculate(distinctcount(Table[Date]))),[_1] >1),[Customer])

SammyNed's avatar
SammyNed
Icon for Helper I rankHelper I
4 years ago

amitchandak 

 

Thank you for your reply, but i don't see how your solution can give me the second graph which needs to include the categorys purchased? Am i missing something?