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.

     

     

     

     

     

     

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.