Forum Discussion
ngiam
Helper I
Helper IHow to perform COUNTIF on Measurement?
Hi, How do I perform a countif using measurement? I have a measurement created to categorize Strength, Weakness, Average. Strength = SWITCH( TRUE, (((Sheet[Superior Score]+Sheet[Tea...
ngiam , sorry my mistake
Strength =
countrows(filter(Sheet,Sheet[Strength] = "Strength"))
Weakness=
countrows(filter(Sheet,Sheet[Strength] = "Weakness"))
Average=
countrows(filter(Sheet,Sheet[Strength] = "Average"))
ngiamHelper I
Helper IHi amitchandak ,
Thank you for your reply.
I encoutered the following issue :
Too few arguments were passed to the FILTER function. The minimum argument count for the function is 2.
Just manage to upload my file here :
https://drive.google.com/drive/folders/12F-Kgb_vvUm13qEdCqOAA_8MJT2IQg2O?usp=sharing
- amitchandak
Super User
ngiam , sorry my mistake
Strength =
countrows(filter(Sheet,Sheet[Strength] = "Strength"))
Weakness=
countrows(filter(Sheet,Sheet[Strength] = "Weakness"))
Average=
countrows(filter(Sheet,Sheet[Strength] = "Average"))
- ngiam
Thank you! This works!