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 L...
"aggregations"
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"