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

     

amitchandak's avatar
amitchandak
Super User
6 years ago

Anonymous 

Can you share sample data and sample output.