Count

[Peter_2020]

rHi all, 

I would like to ask for help with following situation:

I have table with Product Number filtered by the project. And for all products I created:

 - measure "Questions" which calculate how many questions in checklist are related to that product,

 - measure "OK" which calculate how many questions from the checklist was ok and

 - measure "Result" which calculate how many % of the question was ok. 

And I need to calculate how many products had result 100% for selected project (on the picture below it is measure "100% at first time"). Always when I used some of the Count commands I received wrong numbers...

Any idea how to do this?

Thanks.

P.

[Jihwan_Kim · Accepted solution]

Hi,

I am not sure how the Data model looks like, but please try writing a measure something like below.

expected result measure: =
COUNTROWS (
    FILTER ( DISTINCT ( 'TableName'[PRODUCT NUMBER] ), [RESULT Measure] = 1 )
)

[Peter_2020]

Hi @Jihwan_Kim , thank you so much. it works.