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, 

UserChannel   
RamStar sports   
Kiranstar movies   
Ramstar gold   
Ramstar plus   
Adityastar goldpackage1package2package3
AdityahboStar sportsStar sportsStar sports
Ramstar moviesstar moviesstar moviesstar movies
Kiransitistar goldstar goldstar gold
Ramrepublicstar plusstar plusstar plus
Adityabbcstar musicstar musicstar music
Adityazee hbohbo
Rambbc republicrepublic
Kiranbbc  bbc
Rahimbbc  zee
Khanbbc  siti
Rahimclassic  classic
Rahimstar gold   
Khanstar music   
Khanstar gold   
Khanhbo   
Khanstar movies   
Rahimstar 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

  • 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.

     

     

     

     

     

     

3 Replies

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft Employee
    8 years ago

    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'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.