Creating Measure to Categorise an ID based on other columns

[Anonymous]

Hello,

Data Table - 

Customer	Product Ordered
AAA	Tablet
AAA	Mobile
AAA	Mouse
BBB	Mobile
BBB	Mouse
CCC	Mobile
DDD	Tablet

I'm trying to create a measure that gives me below output, it seems pretty easy one but not able to figure out what DAX statements to use, any advice or help on this would be appreciated. Thanks

Desired Output - 

Customers ordering multiple products	Customer Ordering Mobile Only	Customer Ordering Tablet Only
AAA	CCC	DDD
BBB

[Jihwan_Kim · Accepted solution]

Hi, @Anonymous 

Please correct me if I wrongly understood your question.

Please check if the below picture is what you are looking for.

The sample pbix file's link is down below, and all measures are written in the file.

https://www.dropbox.com/s/3zcylylytidjsn6/Mrugankjoshi.pbix?dl=0 

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster.

[Anonymous]

Exactly what I was looking for, appreciate your help! 👍정말 감사합니다

[selimovd]

Hey @Anonymous ,

you can try that with the following measures:

For the multiple products:

Customers ordering multiple products = 
VAR vCustomers =
FILTER (
    ADDCOLUMNS (
        VALUES ( MyTable[Customer] ),
        "NumberSales", CALCULATE ( COUNTROWS ( MyTable ) )
    ),
    [NumberSales] > 1
)

RETURN
SUMX(vCustomers, [NumberSales])

The amount of mobile:

Customer Ordering Mobile Only = 
CALCULATE(
    COUNTROWS( MyTable ),
    MyTable[Product Ordered] = "Mobile"
)

And tablet:

Customer Ordering Tablet Only = 
CALCULATE(
    COUNTROWS( MyTable ),
    MyTable[Product Ordered] = "Tablet"
)

The result looks then like that:

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

[Anonymous]

Thank you, that was helpful 👍