count ID sum of views for that Id is over 1000

[Anonymous]

Hi,

I would like to sum article page views for each article id that is in the data for example below and then count those IDs that have a combined page view total over 1000. Could anyone help? It is to put into a bar graph so needs to be a measure rather than a table as when i sum the page views in a table it works.

So i want COUNT article id if the sum of page views for that ID is over 1000

ID       Views

234     345

234     667

534     234

534     4536

45       87

45       3

Thanks,

[parry2k]

@Anonymous try this

Count over 100 = 
COUNTX (
 suMMARIZE ( Table, Table[Id], "__views", SUM ( Table[View] ),
 IF ( [__views] >= 1000, 1 )
)

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡

[Anonymous]

Thanks @parry2k , it just doesnt like the end bit after IF 

 IF ( [__views] >= 1000, 1 ))

I am trying to rebuild this from QLIK so the qlik expression is  this is at all helpful- 

 

[ryan_mayu]

@Anonymous 

Is this what you want?

Measure 2 = 
VAR SUMMARY=CALCULATE(SUM('Table (2)'[VIEWS]),ALLEXCEPT('Table (2)','Table (2)'[ID]))
RETURN IF(SUMMARY>1000,SUMMARY,BLANK())

[Anonymous]

@ryan_mayu thanks, this is counting all the article page views though rather than by ID 😞 

[parry2k · Accepted solution]

@Anonymous missed a parenthesis

try this

Count over 100 = 
COUNTX (
 suMMARIZE ( Table, Table[Id], "__views", SUM ( Table[View] ) ),
 IF ( [__views] >= 1000, 1 )
)

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡

[Anonymous]

@parry2k  Thank you!!

[Tahreem24]

@Anonymous ,

Measure =
VAR Count=CALCULATE(COUNT('Table'[VIEWS]),ALLEXCEPT('Table','Table'[ID]))
RETURN IF(Count>1000,Count,"-")

[Anonymous]

@Tahreem24

Thanks, it doesnt accpet the count but after VAR though. It is giving me a red line under it.

Thanks,