Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Heavy users

Hi everyone....


I have the need to create categories of frequent users in a given period.
I have the IDs (about 1MM of unique IDS) and I wanted to define for example, who entered Category A more than 10 times a week, who entered Category B 15 times and so on .

 

Tks so much

 

Need Help
  • v-kelly-msft's avatar
    v-kelly-msft
    6 years ago

    Hi Anonymous ，

     

    I created a sample table per your description as below:

    Then you need a measure as below:

     

     

    measure = 
var a =CALCULATE(COUNT('Table'[Category]),ALLEXCEPT('Table','Table'[ID]),FILTER('Table','Table'[Category]="a"))
var b=CALCULATE(COUNT('Table'[Category]),ALLEXCEPT('Table','Table'[ID]),FILTER('Table','Table'[Category]="b"))
Return
IF(a>=10,SELECTEDVALUE('Table'[ID]),IF(b>=15,SELECTEDVALUE('Table'[ID]),BLANK()))

     

    Finally you will see:

     

    Here is the related .pbix file.

     

    Best Regards,
    Kelly
    Did I answer your question? Mark my post as a solution!

     

3 Replies

  • v-kelly-msft's avatar
    v-kelly-msft
    Community Support
    6 years ago

    Hi Anonymous ，

     

    I created a sample table per your description as below:

    Then you need a measure as below:

     

     

    measure = 
var a =CALCULATE(COUNT('Table'[Category]),ALLEXCEPT('Table','Table'[ID]),FILTER('Table','Table'[Category]="a"))
var b=CALCULATE(COUNT('Table'[Category]),ALLEXCEPT('Table','Table'[ID]),FILTER('Table','Table'[Category]="b"))
Return
IF(a>=10,SELECTEDVALUE('Table'[ID]),IF(b>=15,SELECTEDVALUE('Table'[ID]),BLANK()))

     

    Finally you will see:

     

    Here is the related .pbix file.

     

    Best Regards,
    Kelly
    Did I answer your question? Mark my post as a solution!