Forum Discussion

Icon for Helper I rank

Helper I

5 years ago

Solved

How 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[Team Member Score])/2)>3.00), "Strength",

(((Sheet[Superior Score]+Sheet[Team Member Score])/2)<2.20), "Weakness",

((Sheet[Superior Score]+Sheet[Team Member Score])/2)<2.01, "Weakness",

"Average"

)

After that i would like to COUNT the number of strength, weakness and average. Can't seems to link anything to the earlier mentioned measurement.

Is there a way to do this?

Btw, how to post the pbix file? can't seems to find the right place to upload

amitchandak
5 years ago
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"))

4 Replies

amitchandak
Super User
5 years ago
ngiam , if above is a calculated column, then you can create measure like

Strength =

countrows(filter(Sheet[Strength] = "Strength"))

Weakness=

countrows(filter(Sheet[Strength] = "Weakness"))

Average=

countrows(filter(Sheet[Strength] = "Average"))
ngiam
Helper I
5 years ago
Hi 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
  5 years ago
  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
    Helper I
    5 years ago
    Thank you! This works!