Grouping the measures

[rakeshb]

Hello,

I came across a scenario in which I need to assign every user with the subscription packages. 

For example, 

User	Channel
Ram	Star sports
Kiran	star movies
Ram	star gold
Ram	star plus
Aditya	star gold	package1	package2	package3
Aditya	hbo	Star sports	Star sports	Star sports
Ram	star movies	star movies	star movies	star movies
Kiran	siti	star gold	star gold	star gold
Ram	republic	star plus	star plus	star plus
Aditya	bbc	star music	star music	star music
Aditya	zee		hbo	hbo
Ram	bbc		republic	republic
Kiran	bbc			bbc
Rahim	bbc			zee
Khan	bbc			siti
Rahim	classic			classic
Rahim	star gold
Khan	star music
Khan	star gold
Khan	hbo
Khan	star movies
Rahim	star music

I need to assign the packages individually for every user, based on the package category. In this example, rows in the packages are very low, But in my case, they are very large. Please help me with the proper solution.

Thanks,

Rakesh

[v-yulgu-msft]

Hi @rakeshb,

Could you please describe "assign the packages individually for every user, based on the package category" with examples? I don't know how to assign. Besides, please show us you desired output.

Regards,

Yuliana Gu

[rakeshb]

Hi Yuliana @v-yulgu-msft

Sorry for the confusion. Let me reframe the question. Here is the new table.

User	Channel
Ram	Star sports
Kiran	star movies
Ram	star gold
Ram	star plus	package1	package2	package3
Aditya	star gold	Star sports	Star sports	Star sports
Aditya	hbo	star movies	star movies	star movies
Ram	star movies	star gold	star gold	star gold
Kiran	siti	star plus	star plus	star plus
Aditya	bbc	star music	star music	star music
Aditya	zee		hbo	hbo
Rahim	bbc		republic	republic
Khan	republic			bbc
Rahim	classic			zee
Rahim	star gold			siti
Khan	star music			classic
Khan	star gold
Khan	hbo
Khan	star movies
Rahim	star music

In this table, Ram is only using the channels from "Package1", So he should be mapped with package1. In the same way,

Kiran - package3

Rahim - package3 

Khan- package 2

Aditya - package3

The final output I am expecting is 

Package1 - Ram

Package2 - Khan

Package3 - Rahim, Aditya, Kiran

Thanks for the help,

Rakesh.

[Anonymous · Accepted solution]

Not sure if it could help. If you don't have much package list, you can try to get a following Power Bi report.

Use an individual sheets to store packages info

Load the user and package sheets into Power BI and create a column to find out user-package mapping

BelongsTo = IF(CONTAINS(package,package[package1],User[Channel]),"Package1",IF(CONTAINS(package,package[package2],User[Channel]),"Package2",IF(CONTAINS(package,package[package3],User[Channel]),"Package3")))

After that you will be get a report to show package information.