Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Targeting Users by Frequency

Hello,

 

I'm a new user in Power BI and I need help to solve the chalenge bellow. Following 3 Target definitions, I want classify the users.....

Someone can help me ?

 

Thanks in advance.

Rui Luís

 

"aggregations"

3 Replies

  • daxer-almighty's avatar
    daxer-almighty
    Solution Sage
    5 years ago

    Anonymous 

     

    If you want to have a column with User Type, just model your data to facilitate this. Add a column with the number you need (transforming the Sale ID column) in order to create User Type. It's very easy and best done in Power Query, not DAX. Data in columns should always be atomic, which means it should be indivisible from the point of view of the problem you model. Thus, you should add a new column derived from Sale ID so that it's easy to create User Type based on it.

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hi,

       

      Something like this:

      Create the Measure: Number Sale ID = DISTINCTCOUNT(Sale ID)

      And then the 2nd Measure: 

      Target = SWITCH([Number Sale ID],"Medium",2,"Medium",1,"Low","High")
       
      Tks
      Rui
      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        Already got this.....But still with some problems to create "Target"