Forum Discussion

rakeshb's avatar
rakeshb
Frequent Visitor
8 years ago
Solved

Grouping the measures

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 ...
  • Anonymous's avatar
    Anonymous
    8 years ago

    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.

     

     

     

     

     

     

rakeshb's avatar
rakeshb
Frequent Visitor
8 years ago

Hi Yuliana v-yulgu-msft

 

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

 

UserChannel   
RamStar sports   
Kiranstar movies   
Ramstar gold   
Ramstar pluspackage1package2package3
Adityastar goldStar sportsStar sportsStar sports
Adityahbostar moviesstar moviesstar movies
Ramstar moviesstar goldstar goldstar gold
Kiransitistar plusstar plusstar plus
Adityabbcstar musicstar musicstar music
Adityazee hbohbo
Rahimbbc republicrepublic
Khanrepublic  bbc
Rahimclassic  zee
Rahimstar gold  siti
Khanstar music  classic
Khanstar gold   
Khanhbo   
Khanstar movies   
Rahimstar 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's avatar
Anonymous
Not applicable
8 years ago

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.