How to perform COUNTIF on Measurement?

[ngiam]

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

[ngiam]

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 · Accepted solution]

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

[amitchandak]

@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"))